파이널 프로젝트

테이블 (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