파이널 프로젝트
테이블 (12)
category
- category_no — INT
- category_name — VARCHAR(20) — NOT NULL
follower
- email — VARCHAR(50) — 외래 키 → member.email — NOT NULL
- following_email — VARCHAR(50)
image
- image_no — INT — NOT NULL
- file_name — VARCHAR(100) — NOT NULL
- no — INT — NOT NULL
marker
- marker_no — INT — NOT NULL
- story_no — INT — 외래 키 → story.story_no — NOT NULL
- top1 — INT — NOT NULL
- left1 — INT — NOT NULL
- image_no — INT — 외래 키 → image.image_no — NOT NULL
- product_no — INT — 외래 키 → product.product_no — NOT NULL
member
- email — VARCHAR(50) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- pass — VARCHAR(40) — NOT NULL
- zipcode — VARCHAR(80) — NOT NULL
- address1 — VARCHAR(80) — NOT NULL
- address2 — VARCHAR(80) — NOT NULL
- job — VARCHAR(30) — NOT NULL
- phone — VARCHAR(30) — NOT NULL
- picture — VARCHAR(100)
- role — VARCHAR(20) — NOT NULL
notice
- notice_no — INT — NOT NULL
- title — VARCHAR(30) — NOT NULL
- content — VARCHAR(500) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
- email — VARCHAR(50) — 외래 키 → member.email — NOT NULL
- file — VARCHAR(100)
- picture — VARCHAR(100)
- default_comment — INT — NT DEFAULT
product
- product_no — INT — NOT NULL
- product_name — VARCHAR(30) — NOT NULL
- brand_name — VARCHAR(30) — NOT NULL
- product_content — VARCHAR(100) — NOT NULL
reply
- reply_no — INT
- reply_content — VARCHAR(500) — NOT NULL
- reply_date — TIMESTAMP — NOT NULL
- email — VARCHAR(50) — 외래 키 → member.email — NOT NULL
- story_no — INT — 외래 키 → story.story_no — NOT NULL
scrap
- scrap_no — INT — NOT NULL
- email — VARCHAR(50) — 외래 키 → member.email — NOT NULL
- story_no — INT — 외래 키 → story.story_no — NOT NULL
- scrap_date — TIMESTAMP — NOT NULL
story
- story_no — INT — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- email — VARCHAR(50) — 외래 키 → member.email — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
- category_id — VARCHAR(20) — 외래 키 → category.category_no — NOT NULL
- read_count — INT
- thank — INT
- nickname — VARCHAR(30) — NOT NULL
tag
- tag_no — INT — NOT NULL
- tag_name — VARCHAR(30) — NOT NULL
tag_post
- tag_no — INT — 외래 키 → tag.tag_no — NOT NULL
- story_no — INT — 외래 키 → story.story_no — NOT NULL