umc
Tables (11)
inquiry_photos
- id — bigint — Primary key — NOT NULL
- inquiry_id — bigint — Foreign key → inquirys.id — NOT NULL
- user_id — bigint — Foreign key → inquirys.user_id — NOT NULL
- photo_url — text
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — varchar(15)
inquirys
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- type — varchar(15)
- title — varchar(20)
- content — text
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — varchar(15)
missions
- id — bigint — Primary key — NOT NULL
- price — bigint
- point — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — varchar(15)
my_mission
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- mission_id — bigint — Foreign key → missions.id — NOT NULL
- restaurant_name (restaurant_id) — varchar(20)
- mission_amount — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — verchar(15)
points
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- amount — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — varchar(15)
preference_food
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- category — varcahr(20)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — varchar(15)
restaurant_menus
- id — bigint — Primary key — NOT NULL
- restaurant_id — bigint — Foreign key → restaurants.id — NOT NULL
- mission_id — bigint — Foreign key → restaurants.mission_id — NOT NULL
- name — varchar(20)
- price — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — varchar(15)
restaurants
- id — bigint — Primary key — NOT NULL
- mission_id — bigint — Foreign key → missions.id — NOT NULL
- category — varchar(20)
- name — varchar(20)
- address — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — varchar(15)
review_photos
- id — bigint — Primary key — NOT NULL
- review_id — bigint — Foreign key → reviews.id — NOT NULL
- user_id — bigint — Foreign key → reviews.user_id — NOT NULL
- restaurant_id — bigint — Foreign key → reviews.restaurant_id — NOT NULL
- mission_id — bigint — Foreign key → reviews.mission_id — NOT NULL
- photo_url — varchar(100)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — varchar(15)
reviews
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- restaurant_id — bigint — Foreign key → restaurants.id — NOT NULL
- mission_id — bigint — Foreign key → restaurants.mission_id — NOT NULL
- rating — decimal(2,1)
- title — varchar(20)
- content — text
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — varchar(15)
users
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- nickname — varchar(20)
- address — text
- gender — enum
- birth_date — date
- phone_num — bigint
- email — varchar(50)
- created_at — datetime(6)
- updated_at — datetime(6)
- deleted_at — datetime(6)
- status — varchar(15)