UMC-6th

Tables (17)

Badge (Untitled18)

  • badge_id (Key) — Primary key — NOT NULL
  • id (Key3) — Foreign key → user.id — NOT NULL
  • id (Key2) — Foreign key → Genre.id — NOT NULL
  • Field
  • Field2
  • Field3

Genre (Untitled15)

  • id (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Review (Untitled14)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • Field
  • Field2
  • Field3

Review_Genre (Untitled16)

  • id (Key) — Primary key — NOT NULL
  • review_id (Key2) — Foreign key → Review.id — NOT NULL
  • genre_id (Key3) — Foreign key → Genre.id — NOT NULL
  • Field
  • Field2
  • Field3

food_category (Untitled10)

  • id (Key2) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

food_likes (Untitled11)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
  • food_category_id (Key22) — bigint — Foreign key → food_category.id — NOT NULL
  • created_at (Field) — datetime(6)
  • updated_at (Field2) — datetime(6)

inquiry (Untitled5)

  • id (Key2) — bigint — Primary key — NOT NULL
  • member_id (Key) — bigint — Foreign key → member.id — NOT NULL
  • title (Field2) — varchar(20)
  • content (Field4) — text
  • category (Field) — varchar(20)
  • status (Field6) — varchar(20)
  • created_at (Field5) — datetime(6)
  • updated_at (Field3) — datetime(6)

inquiry_img (Untitled9)

  • id (Key) — bigint — Primary key — NOT NULL
  • inquiry_id (Key2) — bigint — Foreign key → inquiry.id — NOT NULL
  • img_url (Field3) — text
  • created_at (Field) — datetime(6)
  • updated_at (Field2) — datetime(6)

member (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(10)
  • nickname (Field2) — varchar(20)
  • gender (Field3) — varchar(10)
  • email (Field10) — varchar(30) — NOT NULL
  • phone_num (Field11) — varchar(15)
  • address (Field12) — varchar(50)
  • birth_date (Field8) — datetime
  • profile_img (Field9) — text
  • created_at (Field4) — datetime(6)
  • updated_at (Field5) — datetime(6)
  • status (Field6) — varchar(15)
  • inactive_date (Field7) — datetime

member_mission (Untitled6)

  • id (Key3) — bigint — Primary key — NOT NULL
  • member_id (Key) — bigint — Foreign key → member.id — NOT NULL
  • mission_id (Key2) — bigint — Foreign key → mission.id — NOT NULL
  • status (Field) — varchar(20)
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

mission (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • store_id (Key2) — bigint — Foreign key → store.id — NOT NULL
  • reward (Field2) — int
  • criteria (Field3) — int
  • expiration_date (Field) — datetime
  • created_at (Field4) — datetime(6)
  • updated_at (Field5) — datetime(6)

region (Untitled12)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(40)
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

review (Untitled3)

  • id (Key2) — bigint — Primary key — NOT NULL
  • member_id (Key) — bigint — Foreign key → member.id — NOT NULL
  • store_id (Key3) — bigint — Foreign key → store.id — NOT NULL
  • content (Field) — text
  • rating (Field4) — double
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

review_img (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • review_id (Key2) — bigint — Foreign key → review.id — NOT NULL
  • img_url (Field) — text
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

store (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • region_id (Key2) — bigint — Foreign key → region.id — NOT NULL
  • name (Field) — varchar(20)
  • category (Field3) — varchar(20)
  • address (Field7) — varchar(50)
  • rating (Field2) — double
  • certification_num (Field8) — varchar(20)
  • close_time (Field4) — datetime
  • created_at (Field5) — datetime(6)
  • updated_at (Field6) — datetime(6)

store_img (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • store_id (Key2) — bigint — Foreign key → store.id — NOT NULL
  • img_url (Field) — text
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

user (Untitled13)

  • id (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3