근태 관리
테이블 (9)
Working_Hour (Untitled5)
- user_id (Key) — 외래 키 → user.id — NOT NULL
- date (Field)
- start (Field2)
- end (Field3)
permmised (Untitled3)
- Key — 기본 키 — NOT NULL
- id (Key2) — 외래 키 → user.id — NOT NULL
- id (Key3) — 외래 키 → team.id — NOT NULL
- date (Field)
position (Untitled8)
- id (Key) — 기본 키 — NOT NULL
- name (Field) — text
- descript (Field2) — text
profile (CopyOfUntitled2)
- user_id (Key2) — 외래 키 → user.id — NOT NULL
- team_id (Key) — 외래 키 → team.id — NOT NULL
- position_id (Key3) — 외래 키 → position.id — NOT NULL
- name (Field) — char
- birth_date (Field2) — date
- phone_number (Field3) — text
- currently_employed (Field5) — boolean
schedule (Untitled6)
- user_id (Key) — 외래 키 → user.id — NOT NULL
- date (Field) — date
- start (Field2) — date
- end (Field3) — date
- vacation (Field4) — choice
schedule_permissed (Untitled7)
- user_id (Key) — 외래 키 → user.id — NOT NULL
- week_start_date (Field) — date
- permissed (Field2) — boolean
team (Untitled2)
- id (Key) — 기본 키 — NOT NULL
- name (Field)
- descript (Field2)
- date (Field3)
user (Untitled)
- id (Key) — 기본 키 — NOT NULL
- user (Field)
- password (Field2)
- email (Field3)
work log (Untitled4)
- user_id (Key) — 외래 키 → user.id — NOT NULL
- date (Field) — datetime
- updated (Field2) — boolean
- content (Field3) — text