Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
setid |
varchar |
2147483647 |
|
|
|
|
|
facility_id |
varchar |
2147483647 |
|
|
|
|
|
effdt |
date |
13 |
|
|
|
|
|
eff_status |
varchar |
2147483647 |
√ |
|
null |
|
|
bldg_cd |
varchar |
2147483647 |
√ |
|
null |
|
|
room |
varchar |
2147483647 |
√ |
|
null |
|
|
descr |
varchar |
2147483647 |
√ |
|
null |
|
|
descrshort |
varchar |
2147483647 |
√ |
|
null |
|
|
facility_type |
varchar |
2147483647 |
√ |
|
null |
|
|
facility_group |
varchar |
2147483647 |
√ |
|
null |
|
|
location |
varchar |
2147483647 |
√ |
|
null |
|
|
room_capacity |
int4 |
10 |
√ |
|
null |
|
|
generl_assign |
varchar |
2147483647 |
√ |
|
null |
|
|
acad_org |
varchar |
2147483647 |
√ |
|
null |
|
|
facility_partition |
varchar |
2147483647 |
√ |
|
null |
|
|
Table contained 1,725 rows at Wed Feb 19 10:31 EST 2014
|