StartupLab

테이블 (5)

user_ assignments

  • user_id — Integer — 외래 키 → 유저.user_id — NOT NULL
  • assignment_id — Integer — 외래 키 → 과제.assignment_id — NOT NULL

과제 (Assignments)

  • assignment_id — Integer — 기본 키 — NOT NULL
  • assignment_name — varchar(255)

업무 (Works)

  • work_id — Integer — 기본 키 — NOT NULL
  • assignment_id — Integer — 외래 키 → 과제.assignment_id — NOT NULL
  • user_id — Integer — 외래 키 → 유저.user_id — NOT NULL
  • work_name — varchar(255)

유저 (Users)

  • user_id — Integer — 기본 키 — NOT NULL
  • username — varchar(255)
  • password — varchar(255)
  • name — varchar(255)
  • user_phone — varchar(255)
  • user_role — Integer
  • user_status — Integer

칼럼 (Columns)

  • column_id — Integer — 기본 키 — NOT NULL
  • work_id — Integer — 외래 키 → 업무.work_id — NOT NULL
  • assignment_id — Integer — 외래 키 → 업무.assignment_id — NOT NULL
  • column_name — varchar(255)
  • column_type — Integer
  • column_contents — JSON