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