umc8th_springboot_week0

Tables (11)

food_category

  • id — BIGINT — Primary key — NOT NULL
  • category — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

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
  • updated_at — DATETIME
  • deleted_at — DATETIME

inquirys

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(50)
  • title — VARCHAR(255)
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

missions

  • id — BIGINT — Primary key — NOT NULL
  • reward — INT
  • content — text
  • deadline — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

my_missions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • mission_id — BIGINT — Foreign key → missions.id — NOT NULL
  • status — ENUM('진행완료', '진행중')
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

preference_food

  • id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → food_category.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

regions

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

restaurants

  • id — BIGINT — Primary key — NOT NULL
  • region_id — BIGINT — Foreign key → regions.id — NOT NULL
  • mission_id — BIGINT — Foreign key → missions.id — NOT NULL
  • name — VARCHAR(50)
  • category — VARCHAR(50)
  • address — VARCHAR(255)
  • status — ENUM('영업중', '마감')
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

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
  • photo_url — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

reviews

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • rating — DECIMAL(2,1)
  • title — VARCHAR(255)
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

users

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • nickname — VARCHAR(50)
  • address — VARCHAR(255)
  • gender — ENUM('M', 'F')
  • birth_date — DATE
  • phone_num — BIGINT
  • email — VARCHAR(50)
  • points — INT
  • completed_mission_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME