VER6
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
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
tbl_doc_detail_reject_reason
- id — bigint — Primary key — NOT NULL
- id (id2) — bigint — Foreign key → tbl_doc_detail.id — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- reason — varchar(255)
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
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)