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)