근태 관리

테이블 (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