실습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