plusx
Tables (4)
APPOROVAL_STATUS (현황)
- status_id (현황id) — int — Primary key — NOT NULL
- approval_id (결재id) — int — Foreign key → APPROVAL.approval_id — NOT NULL
- approver_user_id (결재자id) — int — Foreign key → USER.user_id — NOT NULL
- state (상태(0:검토중, 1:승인, -1:반려)) — int
APPROVAL (결재)
- approval_id (결재id) — int — Primary key — NOT NULL
- type_id (유형id) — int — Foreign key → TYPE.type_id — NOT NULL
- user_id (사용자id) — int — Foreign key → USER.user_id — NOT NULL
- content (내용) — vatchar(500)
- apply_date (적용일) — datetime
- application_date (신청일) — datetime
TYPE (유형)
- type_id (유형id) — int — Primary key — NOT NULL
- type_name (유형이름) — varchar(30)
USER (사용자)
- user_id (사용자id) — int — Primary key — NOT NULL
- user_name (이름) — varchar(20)