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)