week1
Tables (3)
member (Untitled)
- id — BIGINT — Primary key — NOT NULL
- name (VARCHAR(50))
- email (VARCHAR(100))
- github_id (Field3)
- deleted_at (Field4)
member_mission (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- completed_at (Field3) — DATETIME — NOT NULL
- member_id (2) — BIGINT — Foreign key → member.id — NOT NULL — Auto Increment
- mission_id (Key2) — BIGINT — Foreign key → mission.id — NOT NULL — Auto Increment
mission (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- title (Field) — VARCHAR(100)
- description (Field2) — VARCHAR(500) — NOT NULL
- created_at (Field3) — DATETIME