키트웍스 온보딩
테이블 (4)
place
- id — INT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address (ADDRESS) — VARCHAR(256) — NOT NULL
- create_at (Field) — DATETIME — NOT NULL
- modify_at (Field2) — DATETIME
- delete_at (Field3) — DATETIME
study
- id — INT — 기본 키 — NOT NULL
- place_id (PLACE_ID) — INT — 외래 키 → place.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- max_user (MIN_USER) — INT — NOT NULL
- min_user (MAX_USER) — INT — NOT NULL
- create_at (Field) — DATETIME — NOT NULL
- modify_at (Field2) — DATETIME
- delete_at (Field3) — DATETIME
user
- id — INT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(128) — NOT NULL
- create_at — DATETIME — NOT NULL
- modify_at — DATETIME
- delete_at — DATETIME
user_study
- id — INT — 기본 키 — NOT NULL
- role — INT — NOT NULL
- user_id — INT — 외래 키 → user.id — NOT NULL
- study_id — INT — 외래 키 → study.id — NOT NULL
- create_at — DATETIME — NOT NULL
- modify_at — DATETIME
- delete_at — DATETIME