UMC_8th

Tables (15)

food_category (Untitled5)

  • id (아이디(food_category)) — bigint — Primary key — NOT NULL
  • name (음식 종류 이름) — varchar(10)

member (Untitled)

  • id (아이디(member)) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(10)
  • gender (성별) — varchar(10)
  • address (주소) — text
  • point (포인트) — bigint
  • e_mail (이메일) — text
  • phone_num (전화번호) — varchar(15)
  • state (상태) — boolean

member_agree (Untitled2)

  • id (아이디(member_agree)) — bigint — Primary key — NOT NULL
  • id (아이디(member)) — bigint — Foreign key → member.id — NOT NULL
  • id (아이디(terms)) — bigint — Foreign key → terms.id — NOT NULL
  • Field

member_mission (Untitled10)

  • id (아이디(member_mission)) — bigint — Primary key — NOT NULL
  • id (아이디(member)) — bigint — Foreign key → member.id — NOT NULL
  • id (아이디(mission)) — bigint — Foreign key → mission.id — NOT NULL
  • state (상태) — boolean

mission (Untitled11)

  • id (아이디(mission)) — bigint — Primary key — NOT NULL
  • content (내용) — text
  • point (포인트) — int
  • pw (인증번호) — int
  • deadline (마감기한) — datetime

mission_notice (Untitled15)

  • id (아이디(mission_notice)) — bigint — Primary key — NOT NULL
  • id (아이디(notice)) — bigint — Foreign key → notice.id — NOT NULL
  • id (아이디(member)) — bigint — Foreign key → notice.id — NOT NULL
  • title (제목) — varchar(10)
  • content (내용) — varchar(20)

notice (Untitled13)

  • id (아이디(notice)) — bigint — Primary key — NOT NULL
  • id (아이디(member)) — bigint — Foreign key → member.id — NOT NULL
  • state (읽음확인) — boolean

prefer (Untitled4)

  • id (아이디(prefer)) — bigint — Primary key — NOT NULL
  • id (아이디(member)) — bigint — Foreign key → member.id — NOT NULL
  • id (아이디(food_category)) — bigint — Foreign key → food_category.id — NOT NULL

region (Untitled9)

  • id (아이디(region)) — bigint — Primary key — NOT NULL
  • name (지역 이름) — varchar(10)

review (Untitled6)

  • id (아이디(review)) — bigint — Primary key — NOT NULL
  • id (아이디(member)) — bigint — Foreign key → member.id — NOT NULL
  • id (아이디(store)) — bigint — Foreign key → store.id — NOT NULL
  • id (아이디(region)) — bigint — Foreign key → store.id — NOT NULL
  • id (아이디(food_category)) — bigint — Foreign key → store.id — NOT NULL
  • star (별점) — float
  • content (내용) — text

review_image (Untitled8)

  • id (아이디(review_image)) — bigint — Primary key — NOT NULL
  • id (아이디(review)) — bigint — Foreign key → review.id — NOT NULL
  • id (아이디(member)) — bigint — Foreign key → review.id — NOT NULL
  • id (아이디(store)) — bigint — Foreign key → review.id — NOT NULL
  • id (아이디(region)) — bigint — Foreign key → review.id — NOT NULL
  • id (아이디(food_category)) — bigint — Foreign key → review.id — NOT NULL
  • image_url (url) — text

review_notice (Untitled14)

  • id (아이디(review_notice)) — bigint — Primary key — NOT NULL
  • id (아이디(notice)) — bigint — Foreign key → notice.id — NOT NULL
  • id (아이디(member)) — bigint — Foreign key → notice.id — NOT NULL
  • title (제목) — varchar(10)
  • content (내용) — varchar(20)

store (Untitled7)

  • id (아이디(store)) — bigint — Primary key — NOT NULL
  • id (아이디(region)) — bigint — Foreign key → region.id — NOT NULL
  • id (아이디(food_category)) — bigint — Foreign key → food_category.id — NOT NULL
  • name (가게 이름) — varchar(20)
  • address (가게 상세주소) — text
  • star (별점) — float

store_image (Untitled12)

  • id (id(store_image)) — bigint — Primary key — NOT NULL
  • id (아이디(store)) — bigint — Foreign key → store.id — NOT NULL
  • id (아이디(region)) — bigint — Foreign key → store.id — NOT NULL
  • id (아이디(food_category)) — bigint — Foreign key → store.id — NOT NULL
  • image_url (url) — text

terms (Untitled3)

  • id (아이디(terms)) — bigint — Primary key — NOT NULL
  • content (내용) — text
  • state (상태) — boolean