ipu_roominfo

6618 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
agent varchar 30 √ null
roomno varchar 10 √ null
roomid varchar 20 √ null
data text 2147483647 √ null
bno int2 5 √ null
machine_id varchar 9 √ null
refid int2 5 √ null
fromasdb_id int2 5 √ null
share_roomid varchar 1 √ null
share_roomid_cardidx int4 10 √ null
rmk varchar 190 √ null
last_set_wakeup_time timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
ipu_roominfo_pk Primary key Asc id
ipu_roominfo_roomno_idx Performance Asc roomno

Relationships

Close relationships within degrees of separation