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