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