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