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 — 팀장