test

Tables (6)

APPROVAL_HISTORY

  • history_id — NUMBER
  • doc_id — NUMBER — NOT NULL — 문서
  • line_id — NUMBER — 관련
  • actor_id — VARCHAR2(255) — NOT NULL — 행위자
  • action_type — VARCHAR2(20) — NOT NULL — 행위(SUBMIT
  • comment_text — CLOB — 코멘트/반려사유
  • action_date — DATE — 행위

APPROVAL_LINE

  • line_id — NUMBER
  • doc_id — NUMBER — NOT NULL — 문서
  • approver_id — VARCHAR2(255) — NOT NULL — 결재자
  • step_order — NUMBER — NOT NULL — 결재
  • step_status — VARCHAR2(20) — NOT NULL — 단계
  • received_at — DATE — 결재
  • acted_at — DATE — 결재

TEAM

  • team_id — NUMBER
  • team_name — VARCHAR2(100) — NOT NULL — 팀명

TEAM_PERMISSION

  • menu_id — VARCHAR2(255) — Primary key — NOT NULL
  • team_id — NUMBER — Primary key — NOT NULL — 팀
  • can_create — NUMBER(1) — NOT NULL — 생성(저장)
  • can_update — NUMBER(1) — NOT NULL — 수정
  • can_delete — NUMBER(1) — NOT NULL — 삭제

USER_PERMISSION

  • menu_id — VARCHAR2(255) — Primary key — NOT NULL
  • user_id — VARCHAR2(255) — Primary key — NOT NULL — 사용자
  • can_create — NUMBER(1) — NOT NULL — 생성(저장)
  • can_update — NUMBER(1) — NOT NULL — 수정
  • can_delete — NUMBER(1) — NOT NULL — 삭제

USER_TEAM

  • user_id — VARCHAR2(255) — Primary key — NOT NULL
  • team_id — NUMBER — Foreign key → TEAM.team_id — NOT NULL — 팀
  • is_leader — NUMBER(1) — NOT NULL — 팀장