VDR
Tables (19)
access_log (Untitled7)
- id (Key) — bigint — Primary key — NOT NULL
- ref_id (Field) — bigint — NOT NULL — record id
- type (Field2) — string — NOT NULL — table name
- action (Field3) — string — NOT NULL
- timestamp (Field4) — datet — NOT NULL
data_export_histories (Untitled11)
- id (Key) — bigint — Primary key — NOT NULL
- room_id (Key3) — bigint — Foreign key → rooms.id — NOT NULL
- group_id (Key4) — bigint — Foreign key → groups.id — NOT NULL
- group_user_id (Key2) — bigint — Foreign key → users.id — NOT NULL
- id (Key22) — bigint — Foreign key → users.room_id — NOT NULL
- type (Field) — enum(audit_trail, document, folder, qna) — NOT NULL
- output_format (Field2) — enum(xlsx, zip, csv) — NOT NULL
- bucket (Field3) — string(64)
- key (Field4) — string(512)
- payload (Field5) — longtext
- status (Field6) — enum(none, requested, generating. done, failed — NOT NULL
- requested_at (Field7) — date — NOT NULL
- generated_at (Field8) — date
- expiry_at (Field9) — date
- timezone_offset (Field10) — number — NOT NULL
exert_categories (qna_team_answer_team_expert_categories)
- id (Key) — bigint — Primary key — NOT NULL
- category_name — string(64) — NOT NULL
- auto_assign — boolean — NOT NULL
folder_file_privileges (Untitled8)
- id (Key) — bigint — Primary key — NOT NULL
- folder_id (Key2) — bigint — Foreign key → folders.id — NOT NULL
- privileges (Field) — enum — NOT NULL
folder_files (Untitled2)
- id (Key2) — bigint — Primary key — NOT NULL
- room_id (Key5) — bigint — Foreign key → folders.id — NOT NULL
- folder_id (Key32) — bigint — Foreign key → folders.room_id — NOT NULL
- group_user_id (Key) — bigint — Foreign key → users.id — NOT NULL
- index (Field14) — number — NOT NULL
- name (Field) — string(256) — NOT NULL
- size (Field2) — bigint — NOT NULL — size in byte
- document_bucket (Field9) — string(64) — NOT NULL
- document_key (Field10) — string(512) — NOT NULL
- document_ext (Field11) — string(16) — NOT NULL
- docs_pdf_id (Field12) — bigint
- requestUuid (Field13) — string(36)
- status (Field3) — enum(published, partially_published, unpublished) — NOT NULL
- is_deleted (Field8) — boolean — NOT NULL
- is_destroyed (Field6) — boolean — NOT NULL
- created_at (Field4) — date — NOT NULL
- updated_at (Field5) — date
- metadata (Field15) — longtext — 검색을 위한 칼럼
folders
- id (Key) — bigint — Primary key — NOT NULL
- room_id (Key3) — bigint — Foreign key → rooms.id — NOT NULL
- user_id (Key4) — bigint — Foreign key → users.id — NOT NULL
- parent_folder_id (Key2) — bigint — Foreign key → folders.id — NOT NULL
- index (Field3) — integer — NOT NULL
- name (Field) — string(256) — NOT NULL
- size (Field7) — bigint — NOT NULL — size in byte
- status (Field8) — enum(published, partially_published, unpublished) — NOT NULL
- is_deleted (Field6) — boolean — NOT NULL
- is_destroyed (Field2) — boolean — NOT NULL
- created_at (Field4) — date — NOT NULL
group_roles (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- room_id (Key22) — bigint — Foreign key → groups.room_id — NOT NULL
- group_id (Key2) — bigint — Foreign key → groups.id — NOT NULL
- name (Field) — string(64) — NOT NULL
- descriptions (Field2) — string(1024)
- is_destroyed (Field3) — boolean — NOT NULL
- created_at (Field4) — date — NOT NULL
- privileges (Field5) — logntext — file_privileges 를 payload화 시켜 저장
group_user_rel (Untitled5)
- id (Key) — Primary key — NOT NULL
- group_id (Key2) — bigint — Foreign key → groups.id — NOT NULL
- user_id (Key3) — bigint — Foreign key → users.id — NOT NULL
- created_at (Field2) — date — NOT NULL
groups (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- room_id (Key2) — bigint — Foreign key → rooms.id — NOT NULL
- name (Field) — string(64) — NOT NULL
qna_team_answer_team_users (qna_team_answer_teams)
- id (Key4) — bigint — Primary key — NOT NULL
- category_id (Key2) — bigint — Foreign key → exert_categories.id
- user_id (Field) — bigint — NOT NULL
- role (role_id) — enum(expert, answer coordinator) — NOT NULL
qna_team_question_team_users (Untitled10)
- id (Key) — bigint — Primary key — NOT NULL
- qna_team_question_team_id (Key3) — bigint — Foreign key → qna_team_question_teams.id — NOT NULL
- user_id (Field) — bigint — NOT NULL
- role (Field2) — enum(drafter, submitter) — NOT NULL
qna_team_question_teams
- id (Key3) — bigint — Primary key — NOT NULL
- limit_period (Field2) — enum(none, day, week, month, all) — NOT NULL
- limit_high (Field) — number
- limit_medium (Field3) — number
- limit_low (Field4) — number
qna_thread_comments (Untitled13)
- id (Key) — bigint — Primary key — NOT NULL
- folder_document_id (Key22) — bigint — Foreign key → folder_files.id — NOT NULL
- folder_document_thread_id (Key2) — bigint — Foreign key → qna_threads.id — NOT NULL
- user_id (Key4) — bigint — Foreign key → users.id — NOT NULL
- id (Key23) — bigint — Foreign key → users.room_id — NOT NULL
- content (Field) — longtext — NOT NULL
- file_key (Field2) — string(512)
- file_bucket (Field3) — string(512)
- file_name (Field4) — string(256)
- file_ext (Field5) — ext(16)
- is_destroyed (Field6) — boolean — NOT NULL
- created_at (Field7) — date — NOT NULL
- updated_at (Field8) — date
- url (Field9)
- fileId (Field10)
qna_threads (Untitled12)
- id (Key) — bigint — Primary key — NOT NULL
- room_id (Key5) — bigint — Foreign key → folder_files.room_id — NOT NULL
- folder_id (Key32) — bigint — Foreign key → folder_files.folder_id
- folder_document_id (Key2) — bigint — Foreign key → folder_files.id
- assignee_id (Field5) — bigint — ref. group_user_id
- title (Field) — string(256) — NOT NULL
- category (Field2) — string(64)
- priority (Field3) — enum(high, medium, low) — NOT NULL
- status (Field4) — enum(question_draft, question_proposed, question_submitted, answer_draft, answer_proposed, answer_complete — NOT NULL
- is_destroyed (Field7) — boolean — NOT NULL
- created_at (Field6) — date — NOT NULL
- updated_at (Field8) — date
ref_audits
- id (Key) — Primary key — NOT NULL
- ref_id (Key2) — bigint — Foreign key → refs.id — NOT NULL
- service (Field) — string(48)
- type (Field2) — string(64)
- action (Field3) — enum(create, update, delete, read) — NOT NULL
- category (Field4) — string(64)
- reserved_1 (Field5) — string(64)
- reserved_2 (Field6) — string(64)
- reserved_3 (Field7) — string(64)
- reserved_4 (Field8) — string(64)
- reserved_5 (Field9) — string(64)
- before (Field10) — logntext
- after (Field11) — longtext
- reason_key (Field12) — string(128)
- reason (Field13) — string(512)
- actabt_id (Field14) — bigint
- actant_email (Field15) — string(256)
- ip_addr (Field16) — string(64)
- user_agent (Field17) — string(512)
- created_at (Field18) — date — NOT NULL
refs
- id (Key) — bigint — Primary key — NOT NULL
- created_at (Field) — date — NOT NULL
rooms (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- room_name (Field) — string(256) — NOT NULL
- company_name (Field2) — string(256) — NOT NULL
- created_at (Field3) — date — NOT NULL
- updated_at (Field5) — date
- is_destroyed (Field4) — boolean — NOT NULL
- status (Field6) — enum(NotLaunchedYet, Launched, Closed) — NOT NULL
user_data_favorites (Untitled9)
- id (Key) — bigint — Primary key — NOT NULL
- room_id (Key22) — bigint — Foreign key → users.room_id — NOT NULL
- user_id (Key2) — bigint — Foreign key → users.id — NOT NULL
- folder_file_id (Key23) — bigint — Foreign key → folder_files.id
- folder_id (Key32) — bigint — Foreign key → folder_files.folder_id — NOT NULL
- created_at (Field) — date — NOT NULL
users (Untitled6)
- id (Key) — bigint — Primary key — NOT NULL
- room_id (Key2) — bigint — Foreign key → rooms.id — NOT NULL
- user_id (Field) — bigint — NOT NULL — ref_id
- name (Field2) — string(256) — NOT NULL
- email (Field5) — string(256) — NOT NULL
- invite_status (Field6) — enum("NONE", "WAIT", "SENDING", "SENT", "ACCEPTED", "REJECTED", "FAILED") — NOT NULL
- is_destroyed (Field3) — boolean — NOT NULL
- created_at (Field4) — date — NOT NULL