Underdog 신입부원 미니프로젝트
테이블 (3)
Application (Untitled3)
- id (Key) — int — 기본 키 — NOT NULL
- user_id (Key2) — int — 외래 키 → User.id — NOT NULL
- study_id (Key3) — int — 외래 키 → Study.id — NOT NULL
- message (Field3) — varchar
- status (Field4) — varchar
- created_at (Field5) — datetime
- updated_at (Field6) — datetime
Study (Untitled2)
- id (Key) — int — 기본 키 — NOT NULL
- leader_Id (Key2) — int — 외래 키 → User.id — NOT NULL
- title (Field) — varchar
- description (Field2) — varchar
- category (Field3) — varchar
- region (Field4) — varchar
- max_members (Field5) — int
- deadline (Field6) — datetime
- created_at (Field8) — datetime
- updated_at (Field9) — datetime
User (Untitled)
- id (Key) — int — 기본 키 — NOT NULL
- email (Field) — varchar — NOT NULL
- password (Field2) — varchar — NOT NULL
- name (Field3) — varchar — NOT NULL
- created_at (Field4) — datetime — NOT NULL