ㄸㄲㅇ
Tables (6)
files
- file_id — bigint(20) — Primary key — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- content_type — varchar(255) — NOT NULL
- deleted — bit(1) — NOT NULL
- download_hits — bigint(20)
- expiration_at — datetime
- expired — bit(1) — NOT NULL
- file_convert_status — varchar(255)
- file_type — varchar(255) — NOT NULL
- height — int(11)
- name — varchar(255) — NOT NULL
- object_name — varchar(255) — NOT NULL
- session_id — varchar(255) — NOT NULL
- size — bigint(20) — NOT NULL
- uuid — varchar(255) — NOT NULL
- width — int(11)
- room_id — bigint(20) — Foreign key → rooms.room_id
- workspace_id — varchar(255) — NOT NULL
members
- member_id — bigint(20) — Primary key — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- connection_id — varchar(255) — NOT NULL
- device_type — varchar(255) — NOT NULL
- duration_sec — bigint(20) — NOT NULL
- end_at — datetime — NOT NULL
- member_status — varchar(255) — NOT NULL
- member_type — varchar(255) — NOT NULL
- session_id — varchar(255) — NOT NULL
- start_at — datetime — NOT NULL
- uuid — varchar(255) — NOT NULL
- workspace_id — varchar(255) — NOT NULL
- room_id — bigint(20) — Foreign key → rooms.room_id
rooms
- room_id — bigint(20) — Primary key — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- active_at — datetime
- audio_restricted_mode — bit(1)
- description — varchar(255)
- leader_id — varchar(255) — NOT NULL
- license_name — varchar(255) — NOT NULL
- max_user_count — int(11) — NOT NULL
- profile — varchar(255)
- room_status — int(11) — NOT NULL
- session_id — varchar(255)
- title — varchar(255) — NOT NULL
- video_restricted_mode — bit(1)
- workspace_id — varchar(255) — NOT NULL
workspace
- workspace_id — bigint — Primary key — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- description — varchar(255)
- name — varchar(255)
- pin_number — varchar(6) — NOT NULL
- profile — varchar(255)
- user_id — varchar(255) — NOT NULL
- uuid — varchar(255) — NOT NULL
workspace_permission
- workspace_permission_id — bigint — Primary key — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- description — longtext
- permission — varchar(255) — NOT NULL
workspace_user
- workspace_user_id — bigint — Primary key — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- user_id — varchar(255) — NOT NULL
- workspace_id — bigint — Foreign key → workspace.workspace_id
- role — varchar2(255)
- workspace_permission_id — bigint — Foreign key → workspace_permission.workspace_permission_id