dd
Tables (7)
location_mission (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (Key3) — bigint — Foreign key → member.id — NOT NULL
- complete_count (Field) — int
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
member
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(10)
- nickname (Field2) — varchar(20)
- gender (Field3) — varchar(10)
- birth (Field4) — varchar(10)
- address (Field5) — varchar(100)
- email (Field13) — text
- phone_num (Field12) — varchar(20)
- favorite_food (Field6) — set
- point (Field7) — int
- status (Field8) — enum
- inactive (Field9) — datetime(6)
- updated_at (Field11) — datetime(6)
- created_at (Field10) — datetime(6)
mission (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- location_mission_id (Key3) — bigint — Foreign key → location_mission.id — NOT NULL
- content (Field) — varchar(50)
- location (Field2) — varchar(20)
- is_started (Field3) — boolean
- is_complete (Field4) — boolean
- deadline (Field5) — date
- serial_number (Field6) — int
- created_at (Field7) — datetime(6)
- updated_at (Field8)
mission_restaurant (Untitled5)
- mission_id (Key) — bigint — Foreign key → mission.id — NOT NULL
- restaurant_id (Key2) — bigint — Foreign key → restaurant.id — NOT NULL
mission_review (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- mission_id (Key4) — bigint — Foreign key → mission.id — NOT NULL
- review_id (Key2) — bigint — Foreign key → review.id — NOT NULL
restaurant (Untitled6)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(10)
- address (Field2) — varchar(100)
- type (Field3) — enum
- created_at (Field4) — datetime(6)
- updated_at (Field5) — datetime(6)
review (Untitled7)
- id (Key) — bigint — Primary key — NOT NULL
- content (Field) — text
- rating (Field2) — int
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)