smart-labs
Tables (4)
meeting
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → user.user_id — NOT NULL
- user_uid — int — NOT NULL
- subject — varchar(1000) — NOT NULL
- startT — varchar(20) — NOT NULL
- endT — varchar(20) — NOT NULL
- members — varchar(1000)
- roomNumber — int
message
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → user.user_id — NOT NULL
- from_uid — int — NOT NULL
- to_uid — int — NOT NULL
- body — varchar(1000)
- mtime — varchar(19) — NOT NULL
- is_seen — int
- title — varchar(20)
user
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Primary key — NOT NULL
- password — varchar(50) — NOT NULL
- name — varchar(20)
- gender — varchar(20)
- position — varchar(20)
- team — varchar(20)
- rank — varchar(20)
- seat_id — int
- type — varchar(20)
- email — varchar(50)
- custom_data_1 — varchar(20)
- custom_data_2 — varchar(20)
- custom_data_3 — varchar(20)
- custom_data_4 — varchar(20)
- monitor_index — int
- monitor_screen_index — int
- keyboard_index — int
- mouse_index — int
- plant_index — int
- bottle_index — int
- privatePic_url — varchar(500)
- plant_transform_x — float(8,5)
- plant_transform_y — float(8,5)
- plant_transform_z — float(8,5)
- plant_transform_rx — float(8,5)
- plant_transform_ry — float(8,5)
- plant_transform_rz — float(8,5)
- bottle_transform_x — float(8,5)
- bottle_transform_y — float(8,5)
- bottle_transform_z — float(8,5)
- bottle_transform_rx — float(8,5)
- bottle_transform_ry — float(8,5)
- bottle_transform_rz — float(8,5)
- privatePic_transform_x — float(8,5)
- privatePic_transform_y — float(8,5)
- privatePic_transform_z — float(8,5)
- privatePic_transform_rx — float(8,5)
- privatePic_transform_ry — float(8,5)
- privatePic_transform_rz — float(8,5)
- firebase_uid — varchar(30)
- firebase_company_uid — varchar(30)
user_log
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → user.user_id — NOT NULL
- uid — int — NOT NULL
- type — varchar(10)
- time — varchar(20)