1

Tables (6)

tbl_doc

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • is_updated — bit(1) — NOT NULL
  • title — varchar(255)
  • tbl_doc_type_id — bigint — Foreign key → tbl_doc_type.id

tbl_doc_detail

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • content — varchar(255)
  • created_by — bigint
  • external_file_url — varchar(255)
  • original_file_name — varchar(255)
  • status — enum('APPROVED','CHECKED','PENDING','REJECTED')
  • upload_file_url — varchar(255)
  • version — varchar(255)
  • tbl_doc_id — bigint — Foreign key → tbl_doc.id

tbl_doc_detail_reject_reason

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • reason — varchar(255)
  • tbl_doc_detail_id — bigint — Foreign key → tbl_doc_detail.id

tbl_doc_req

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • assignee — varchar(255)
  • content — varchar(255)
  • status — enum('COMPLETED','IN_PROGRESS','PENDING')
  • title — varchar(255)
  • tbl_doc_id — bigint — Foreign key → tbl_doc.id

tbl_doc_type

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • created_by — bigint
  • name — varchar(255)

tbl_member

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • name — varchar(255)
  • password — varchar(255)
  • role — enum('TEAM_LEADER','TEAM_MEMBER')
  • username — varchar(255)