AnnualLeave

Tables (4)

Department (부서)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Member (사용자)

  • username (Key) — varchar(255) — Primary key — NOT NULL
  • id (Key4) — BIGINT — Foreign key → position.id — NOT NULL
  • department_id (2) — BIGINT — Foreign key → position.department_id — NOT NULL
  • username (FK) — varchar(255) — Foreign key → position.username — NOT NULL
  • password (Field) — varchar(255)
  • email (Field2) — varchar(255)
  • deleted (Field3) — TINYINT
  • birthdate (Field4) — varchar(255)
  • years (Field5) — varchar(255)
  • employee_number (Field6)
  • name (Field7) — varchar(255)
  • phone_number (Field8) — varchar(255)

Untitled

  • id (Key) — BIGINT — Primary key — NOT NULL
  • username (Key2) — varchar(255) — Foreign key → Member.username — NOT NULL
  • id (Key4) — BIGINT — Foreign key → Member.id — NOT NULL
  • department_id (22) — BIGINT — Foreign key → Member.department_id — NOT NULL
  • username (FK) — varchar(255) — Foreign key → Member.username — NOT NULL
  • Field

position (직급)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • department_id — BIGINT — Primary key — NOT NULL
  • username (FK) — varchar(255) — Primary key — NOT NULL
  • name (Field2) — varchar(255)
  • restriction (Field) — varchar(255)
  • Field3