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