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