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