SEMES
Tables (6)
department_managers
- department_id — UUID — Foreign key → departments.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- assigned_by — UUID — Foreign key → users.id
- assigned_at — TIMESTAMPTZ — NOT NULL
department_policies
- department_id — UUID — Foreign key → departments.id — NOT NULL
- share_mode — drawing_share_mode — NOT NULL
- auto_approve_intra_team — BOOLEAN — NOT NULL — 같은
- auto_approve_cross_team — BOOLEAN — NOT NULL — 타
- allow_re_request_after_reject — BOOLEAN — NOT NULL — 거절
- re_request_cooldown_hours — INTEGER — NOT NULL — 재요청
- max_grant_duration_days — INTEGER — grant
- default_grant_duration_days — INTEGER — 만료
- updated_by — UUID — Foreign key → users.id
- updated_at — TIMESTAMPTZ — NOT NULL
departments
- id — UUID — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- parent_id — UUID — Foreign key → departments.id — 상위
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
drawing_access_grants
- id — UUID — Primary key — NOT NULL
- drawing_id — UUID — Foreign key → drawings.id — NOT NULL
- grantee_user_id — UUID — Foreign key → users.id — NOT NULL — 권한
- requested_by — UUID — Foreign key → users.id — 요청자
- approver_user_id — UUID — Foreign key → users.id — 최종
- status — drawing_grant_status — NOT NULL — PENDING_LEAD/PENDING_CHIEF/APPROVED/REJECTED/REVOKED
- scope — drawing_grant_scope — NOT NULL — INTRA_TEAM/CROSS_TEAM/OWNER_SELF
- lca_department_id — UUID — Foreign key → departments.id — CROSS_TEAM일
- expires_at — TIMESTAMPTZ — NULL이면
- approved_at — TIMESTAMPTZ
- rejected_at — TIMESTAMPTZ
- revoked_at — TIMESTAMPTZ
- rejection_reason — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
drawings
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- drawing_no — VARCHAR(50) — NOT NULL
- source_file — VARCHAR(500) — NOT NULL — 저장된
- input_format — VARCHAR(10) — NOT NULL — PDF/PNG/JPG/JPEG/TIF/TIFF/DXF/DWG
- size_bytes — INTEGER — NOT NULL
- pipeline_route — VARCHAR(10)
- engine — VARCHAR(20) — 추론
- status — drawing_status — NOT NULL — UPLOADED/PROCESSING/COMPLETED/FAILED
- result — JSONB — 분석
- queued_at — TIMESTAMPTZ
- parsed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users
- id — UUID — Primary key — NOT NULL
- login_id — VARCHAR(100)
- hashed_password — VARCHAR(255) — argon2id
- must_change_password — BOOLEAN — NOT NULL — 임시비번
- temp_password_expires_at — TIMESTAMPTZ — 임시비번
- name — VARCHAR(100) — 성함
- department_id — UUID — Foreign key → departments.id — 소속
- role — user_role — NOT NULL — admin/manager/engineer
- status — user_status — NOT NULL — PENDING/ACTIVE/REJECTED/DELETED
- approved_by — UUID — Foreign key → users.id
- approved_at — TIMESTAMPTZ
- rejected_by — UUID — Foreign key → users.id
- rejected_at — TIMESTAMPTZ
- rejection_reason — TEXT
- terms_agreed_at — TIMESTAMPTZ — 약관
- deleted_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL