1차 프로젝트

테이블 (12)

dessert

  • id (dessert_id) — VARCHAR(2) — 기본 키 — NOT NULL
  • desc (dessert_desc) — VARCHAR(20) — NOT NULL
  • id (menu_id) — INT — 외래 키 → menu.id — NOT NULL — AI

menu

  • id (menu_id) — INT — 기본 키 — NOT NULL — AI
  • name (menu_name) — VARCHAR(20)
  • price — INT
  • desc (menu_desc) — VARCHAR(30)
  • image (menu_image_path) — VARCHAR(255)
  • store_id — INT — 외래 키 → store.id — NOT NULL — AI

post

  • id (post_id) — INT — 기본 키 — NOT NULL — AI
  • content — VARCHAR(1000) — NOT NULL
  • title — VARCHAR(20) — NOT NULL
  • date (posted_date) — DATE — NOT NULL
  • member (user_id) — VARCHAR(20) — 외래 키 → users.id — NOT NULL
  • id (post_category_id) — VARCHAR(2) — 외래 키 → post_category.id — NOT NULL
  • Field (views) — INT — NOT NULL

post_category

  • id (post_category_id) — VARCHAR(2) — 기본 키 — NOT NULL
  • desc (post_desc) — VARCHAR(20) — NOT NULL

post_comment

  • id (post_comment_id) — INT — 기본 키 — NOT NULL — AI
  • content — VARCHAR(100) — NOT NULL
  • date (posted_date) — DATE — NOT NULL
  • id (post_id) — INT — 외래 키 → post.id — NOT NULL — AI
  • id (user_id) — VARCHAR(20) — 외래 키 → users.id — NOT NULL
  • id (parent_comment) — INT — 외래 키 → post_comment.id

post_image

  • id (post_image_id) — INT — 기본 키 — NOT NULL
  • path (post_image_path) — varchar(100) — NOT NULL
  • post_id — INT — 외래 키 → post.id — NOT NULL

recommendation (Untitled)

  • id (recommendation_id) — 기본 키 — NOT NULL
  • type (reference_type) — varchar(1) — NOT NULL
  • id (reference_id) — int — NOT NULL
  • date (posted_date) — date — NOT NULL
  • id (user_id) — VARCHAR(20) — 외래 키 → users.id — NOT NULL

review

  • id (review_id) — INT — 기본 키 — NOT NULL — AI
  • content — VARCHAR(1000) — NOT NULL
  • date (posted_date) — DATE — NOT NULL
  • star — INT — NOT NULL
  • image (review_image_path) — VARCHAR(255)
  • store_id — INT — 외래 키 → store.id — NOT NULL — AI
  • user_id — VARCHAR(20) — 외래 키 → users.id — NOT NULL — AI

review_comment

  • id (review_comment_id) — INT — 기본 키 — NOT NULL — AI
  • content — VARCHAR(100) — NOT NULL
  • date (posted_date) — DATE — NOT NULL
  • id (review_id) — INT — 외래 키 → review.id — NOT NULL — AI
  • id (user_id) — VARCHAR(20) — 외래 키 → users.id — NOT NULL
  • id (parent_comment) — INT — 외래 키 → review_comment.id

store

  • id (store_id) — INT — 기본 키 — NOT NULL — AI
  • name (store_name) — VARCHAR(20) — NOT NULL
  • address — VARCHAR(40) — NOT NULL
  • phone_number — VARCHAR(12) — NOT NULL
  • desc (store_desc) — VARCHAR(100) — NOT NULL
  • latitude — FLOAT
  • longitude — FLOAT
  • image (store_image_path) — VARCHAR(100)
  • user_id — VARCHAR(20) — 외래 키 → users.id — NOT NULL

users (member)

  • id (user_id) — VARCHAR(20) — 기본 키 — NOT NULL
  • pw (user_password) — VARCHAR(20) — NOT NULL
  • name (user_name) — varchar(20) — NOT NULL
  • nicname (nickname) — varchar(20) — NOT NULL
  • email (user_email) — varchar(20) — NOT NULL
  • image (user_image_path) — varchar(255)
  • role — varchar(15) — NOT NULL
  • status — varchar(15) — NOT NULL
  • gender — varchar(1) — NOT NULL
  • birth — DATE — NOT NULL

views

  • id (views_id) — INT — 기본 키 — NOT NULL — AI
  • type (reference_type) — varchar(1) — NOT NULL
  • id (reference_id) — int — NOT NULL
  • date (viewed_date) — date — NOT NULL