intf_room

1165 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
agent_code text 2147483647 null
intf_agent.code intf_room_agent_code_fk C
room_id int4 10 null
room.id intf_room_room_id_fk C
intf_room_id text 2147483647 √ null
room_data jsonb 2147483647 √ null
shared_room bool 1 √ false
shared_card_index int4 10 √ null
remark text 2147483647 √ null
access_code text 2147483647 √ null
card_serial text 2147483647 √ null
card_index int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
intf_room_pkey Primary key Asc id
idx_intf_room_agent_code Performance Asc agent_code
idx_intf_room_room_id Performance Asc room_id
intf_room_unq Must be unique Asc/Asc agent_code + room_id

Relationships

Close relationships within degrees of separation