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