sub Project
Tables (3)
members (Untitled2)
- id (pk) — not null — Primary key — NOT NULL
- user_id (pk2) — not null — Foreign key → users.id — NOT NULL
- group_id (Field4) — not null — 조직아이디
- position_id (Field3) — not null — 직무아이디
- name (Field) — not null
- mphone (Field5) — not null
- birthday (Field6) — not null
- address (Field7) — not null
- gender (Field8) — null
- date_of_join (Field9) — now() — 입사일
- date_of_quite (Field10) — null
- created_at (Field2) — now()
- updated_at (Field11) — now()
- deleted_at (Field12) — null
positions (Untitled3)
- Key — Primary key — NOT NULL
users (Untitled)
- id (pk) — not null — Primary key — NOT NULL
- email (Field) — not null
- password (Field2) — not null
- created_at (Field3) — now()
- updated_at (Field4) — now()
- deleted_at (Field5) — null