실습1

테이블 (10)

BOARD

  • bNO — INT — 기본 키 — NOT NULL
  • mNO — VARCHAR(30) — 외래 키 → MEMBER.mNO — NOT NULL
  • TYPE — VARCHAR(20) — 외래 키 → 게시판 카테고리.TYPE — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • ATTACHCOUNT — INT — NOT NULL
  • readcount — INT — NOT NULL
  • CREATE_DATE — TIMESTAMP — NOT NULL
  • MODIFY_DATE — TIMESTAMP — NOT NULL
  • status — VARCHAR(1) — NOT NULL

BOARD_ATTACH_FILE

  • fNo — INT — 기본 키 — NOT NULL
  • bNO — INT — 외래 키 → BOARD.bNO — NOT NULL
  • mNO — VARCHAR(30) — 외래 키 → BOARD.mNO — NOT NULL
  • TYPE2 — VARCHAR(20) — 외래 키 → BOARD.TYPE — NOT NULL
  • origianl_filename — VARCHAR(200) — NOT NULL
  • renamed_filename — VARCHAR(200) — NOT NULL
  • CREATE_DATE — TIMESTAMP — NOT NULL

BOARD_NEWS

  • newsNo — INT — 기본 키 — NOT NULL
  • TYPE — VARCHAR(20) — 외래 키 → 게시판 카테고리.TYPE — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • newsImgUrl — text — NOT NULL
  • mnewsImgUrl — text — NOT NULL
  • views — INT — NOT NULL
  • createdDate — TIMESTAMP — NOT NULL
  • modifiedDate — TIMESTAMP — NOT NULL
  • status — VARCHAR(1) — NOT NULL

CART

  • mNO — VARCHAR(30) — 외래 키 → MEMBER.mNO — NOT NULL
  • pNO — INT — 외래 키 → PRODUCT.pNO — NOT NULL
  • mNO2 — INT — 외래 키 → PRODUCT.mNO — NOT NULL
  • AMOUNT — INT — NOT NULL
  • PRICE — INT — NOT NULL

MEMBER

  • mNO — INT — 기본 키 — NOT NULL
  • ID — VARCHAR(30) — NOT NULL
  • password — VARCHAR(30) — NOT NULL
  • role — VARCHAR(10) — NOT NULL — 회원, 약사,관리자
  • name — VARCHAR(30) — NOT NULL
  • phone — VARCHAR(30) — NOT NULL
  • email — VARCHAR(30) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • KAKAOTOKEN — VARCHAR(1000) — NOT NULL
  • status — VARCHAR(1) — NOT NULL
  • enrollDate — DATE — NOT NULL
  • modifyDate — DATE — NOT NULL
  • mstatus — VARCHAR(1) — NOT NULL — 일반

ORDERS

  • oNO — BIGINT(20) — 기본 키 — NOT NULL
  • mNO — VARCHAR(30) — 외래 키 → MEMBER.mNO — NOT NULL
  • pNO — INT — 외래 키 → PRODUCT.pNO — NOT NULL
  • mNO2 — INT — 외래 키 → PRODUCT.mNO — NOT NULL
  • payMethod — VARCHAR(50) — NOT NULL
  • totalPrice — INT(10) — NOT NULL
  • requests — VARCHAR(100)
  • createdDate — TIMESTAMP — NOT NULL
  • modifyDate — TIMESTAMP — NOT NULL
  • status — VARCHAR(1) — NOT NULL

PRODUCT

  • pNO — INT — 기본 키 — NOT NULL
  • mNO — INT — 외래 키 → MEMBER.mNO — NOT NULL
  • TITLE — VARCHAR(1000) — NOT NULL
  • LINK — VARCHAR(1000) — NOT NULL
  • IMAGE — VARCHAR(1000) — NOT NULL
  • LPRICE — INT — NOT NULL
  • HPRICE — INT — NOT NULL
  • MALLNAME — VARCHAR(1000) — NOT NULL
  • PRODUCTID — VARCHAR(1000) — NOT NULL
  • PRODUCTTYPE — VARCHAR(1000) — NOT NULL
  • MAKER — VARCHAR(1000) — NOT NULL
  • BRAND — VARCHAR(1000) — NOT NULL
  • category1 — VARCHAR(1000) — NOT NULL
  • category2 — VARCHAR(1000) — NOT NULL
  • category3 — VARCHAR(1000)
  • category4 — VARCHAR(1000)
  • pAMOUNT — INT — NOT NULL

PRODUCTREPLY

  • rNO — INT — 기본 키 — NOT NULL
  • mNO — INT — 외래 키 → MEMBER.mNO — NOT NULL
  • pNO — INT — 외래 키 → PRODUCT.pNO — NOT NULL
  • mNO2 — INT — 외래 키 → PRODUCT.mNO — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • rating — INT — NOT NULL
  • CREATEDATE — TIMESTAMP — NOT NULL

REPLY_BOARD

  • rNO — INT — 기본 키 — NOT NULL
  • bNO — INT — 외래 키 → BOARD.bNO — NOT NULL
  • mNO — VARCHAR(30) — 외래 키 → BOARD.mNO — NOT NULL
  • TYPE2 — VARCHAR(20) — 외래 키 → BOARD.TYPE — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • create_DATE — TIMESTAMP — NOT NULL
  • modify_DATE — TIMESTAMP — NOT NULL
  • status — VARCHAR(1) — NOT NULL

게시판 카테고리 (BOARD_CATEGORY)

  • TYPE — VARCHAR(20) — 기본 키 — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL
  • LEVEL — INT — NOT NULL
  • ORDERNO — INT — NOT NULL