Chapter 1 Mission
Tables (9)
User (Untitled)
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6)
- uid — varchar(20)
- password — varchar(20)
- email — varchar(30) — NOT NULL
- gender — varchar(10) — NOT NULL
- birth — date — NOT NULL
- address — varchar(30) — NOT NULL
- point — int
- status — varchar(15) — NOT NULL
- inactivate_date — datetime
mission (Untitled3)
- id — bigint — Primary key — NOT NULL
- user_id (id2) — bigint — Foreign key → User.id — NOT NULL
- restaurant_id (id3) — bigint — Foreign key → restaurant.id — NOT NULL
- point — int
- meal_price — int
- due_date — date
- status — varchar(15) — NOT NULL
- identification_number — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
notification (Untitled7)
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → User.id — NOT NULL
- type — varchar(30)
- is_read — boolean
- created_at — datetime(6)
point_history (Untitled8)
- id — bigint — Primary key — NOT NULL
- user_id (id2) — bigint — Foreign key → User.id — NOT NULL
- amount — int
- type — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
preference_category (Untitled2)
- id — bigint — Primary key — NOT NULL
- name — varchar(10)
restaurant (Untitled6)
- id — bigint — Primary key — NOT NULL
- name — varchar(30)
- category (Field) — varchar(30)
- address — varchar(50)
- created_at — datetime(6)
- updated_at — datetime(6)
- image — varchar(50)
review (Untitled4)
- id — bigint — Primary key — NOT NULL
- mission_id (id2) — bigint — Foreign key → mission.id — NOT NULL
- user_id (id22) — bigint — Foreign key → mission.user_id — NOT NULL
- restaurant_id (id3) — bigint — Foreign key → mission.restaurant_id — NOT NULL
- rating — float
- content — text
- created_at — datetime(6)
- updated_at — datetime(6)
review_img (Untitled9)
- id (Key) — bigint — Primary key — NOT NULL
- review_id (id) — bigint — Foreign key → review.id — NOT NULL
- mission_id (id2) — bigint — Foreign key → review.mission_id — NOT NULL
- user_id (id22) — bigint — Foreign key → review.user_id — NOT NULL
- restaurant_id (id3) — bigint — Foreign key → review.restaurant_id — NOT NULL
- Field — varchar(255)
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
user_preference (Untitled5)
- id — bigint — Primary key — NOT NULL
- category_id (id2) — bigint — Foreign key → preference_category.id — NOT NULL
- user_id (id3) — bigint — Foreign key → User.id — NOT NULL