2ㅈ23
Tables (17)
BOARD
- BOARDNUM — NUMBER
- MEMBERID — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID — NOT NULL
- BOARDTITLE — VARCHAR2(100) — NOT NULL
- BOARDCONTENTS — CLOB — NOT NULL
- BOARDDATE — DATE — NOT NULL
- BOARDHIT — NUMBER
- BOARDCOMMENTCOUNT — NUMBER
BOARDCOMMENT
- BOARDCOMMENTNUM — NUMBER — Foreign key → BOARD.BOARDNUM
- BOARDNUM — NUMBER — NOT NULL
- MEMBERID — VARCHAR2(100) — NOT NULL
- BOARDCOMMENTCONTENTS — CLOB — NOT NULL
- BOARDCOMMENTDATE — DATE — NOT NULL
- BOARDCOMMENTREF — NUMBER — NOT NULL
- BOARDCOMMENTSTEP — NUMBER — NOT NULL
- BOARDCOMMENTDEPTH — NUMBER — NOT NULL
CART
- CARTNUM — NUMBER
- MEMBERID — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID
- PRODUCTNUM — NUMBER — Foreign key → PRODUCT.PRODUCTNUM
- ORDERSTOCK — NUMBER
CHAT
- CHATNUM — NUMBER
- ROOM — NUMBER — NOT NULL
- SENDID — VARCHAR2(100) — NOT NULL
- RECVID — VARCHAR2(100) — NOT NULL
- SENDTIME — TIMESTAMP — NOT NULL
- READTIME — TIMESTAMP — NOT NULL
- CONTENT — VARCHAR2(1000) — NOT NULL
- READCHECK — NUMBER — NOT NULL
- EXITID — VARCHAR2(50) — NOT NULL
- EXITCOUNT — NUMBER(5)
LESSON
- LESSONNUM — NUMBER
- MEMBERID — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID — NOT NULL
- LESSONTITLE — VARCHAR2(100) — NOT NULL
- LESSONTEACHER — VARCHAR2(100) — NOT NULL
- LESSONURL — VARCHAR2(400) — NOT NULL
- LESSONCONTENTS — CLOB — NOT NULL
- LESSONHIT — NUMBER
- LESSONDATE — DATE — NOT NULL
LESSONIMG
- LESSONIMGNUM — NUMBER
- LESSONNUM — NUMBER — Foreign key → LESSON.LESSONNUM — NOT NULL
- IMGNAME — VARCHAR2(100) — NOT NULL
- ORIGINALNAME — VARCHAR2(100) — NOT NULL
LESSONREVIEW
- LESSONREVIEWNUM — NUMBER
- LESSONNUM — NUMBER — Foreign key → LESSON.LESSONNUM — NOT NULL
- MEMBERID — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID — NOT NULL
- LESSONREVIEWCONTENTS — CLOB — NOT NULL
- LESSONREVIEWDATE — DATE — NOT NULL
- LESSONRATING — NUMBER(2,1) — NOT NULL
MEMBER
- MEMBERID — VARCHAR2(100)
- MEMBERPW — VARCHAR2(100) — NOT NULL
- MEMBERNAME — VARCHAR2(100) — NOT NULL
- MEMBERPHONE — VARCHAR2(100)
- MEMBERADDRESS1 — VARCHAR2(200)
- MEMBERADDRESS2 — VARCHAR2(200)
- MEMBERADDRESS3 — VARCHAR2(200)
- MEMBEREMAIL — VARCHAR2(100)
- ADMINCHECK — NUMBER
- MEMBERGENDER — VARCHAR2(100) — NOT NULL
- MEMBERSI — CLOB
- MEMBERAGE — NUMBER — NOT NULL
- MONEY — NUMBER
ORDER
- ORDERNUM — VARCHAR2(100)
- ADDRESSEE — VARCHAR2(100) — NOT NULL
- MEMBERID — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID
- MEMBERADDRESS1 — VARCHAR2(200) — NOT NULL
- MEMBERADDRESS2 — VARCHAR2(200) — NOT NULL
- MEMBERADDRESS3 — VARCHAR2(200) — NOT NULL
- ORDERSTATE — VARCHAR2(100) — NOT NULL
- ORDERCOMMENT — VARCHAR2(100)
- ORDERFEE — NUMBER — NOT NULL
- ORDERDATE — DATE
ORDERITEM
- ORDERITEMNUM — NUMBER
- PRODUCTNUM — NUMBER — Foreign key → PRODUCT.PRODUCTNUM
- ORDERNUM — VARCHAR2(100) — Foreign key → ORDER.ORDERNUM
- ORDERSTOCK — NUMBER — NOT NULL
- PRODUCTPRICE — NUMBER — NOT NULL
PRODUCT
- PRODUCTNUM — NUMBER
- MEMBERID — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID — NOT NULL
- PRODUCTNAME — VARCHAR2(100) — NOT NULL
- PRODUCTDETAIL — CLOB — NOT NULL
- PRODUCTSTOCK — NUMBER
- PRODUCTPRICE — NUMBER — NOT NULL
- PRODUCTDATE — DATE — NOT NULL
- PRODUCTSTATE — NUMBER(1,0)
PRODUCTIMG
- PRODUCTIMGNUM — NUMBER
- PRODUCTNUM — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- IMGNAME — VARCHAR2(100) — NOT NULL
- ORIGINALNAME — VARCHAR2(100) — NOT NULL
PRODUCTQNA
- PRODUCTQNANUM — NUMBER
- PRODUCTNUM — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- MEMBERID — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID — NOT NULL
- PRODUCTQNATITLE — VARCHAR2(100) — NOT NULL
- PRODUCTQNACONTENTS — CLOB — NOT NULL
- PRODUCTQNADATE — DATE — NOT NULL
- PRODUCTQNAREF — NUMBER — NOT NULL
- PRODUCTQNASTEP — NUMBER — NOT NULL
- PRODUCTQNADEPTH — NUMBER — NOT NULL
- PRODUCTQNASECRET — NUMBER(1,0) — NOT NULL
PRODUCTREVIEW
- PRODUCTREVIEWNUM — NUMBER
- PRODUCTNUM — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- MEMBERID — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID — NOT NULL
- PRODUCTREVIEWCONTENTS — CLOB — NOT NULL
- PRODUCTREVIEWTITLE — VARCHAR2(100) — NOT NULL
- PRODUCTREVIEWDATE — DATE — NOT NULL
- PRODUCTRATING — NUMBER(2,1) — NOT NULL
PRODUCTREVIEWIMG
- PRODUCTREVIEWIMGNUM — NUMBER
- PRODUCTREVIEWNUM — NUMBER — Foreign key → PRODUCTREVIEW.PRODUCTREVIEWNUM — NOT NULL
- IMGNAME — VARCHAR2(100) — NOT NULL
- ORIGINALNAME — VARCHAR2(100) — NOT NULL
RECIPE
- RECIPENUM — NUMBER
- MEMBERID — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID — NOT NULL
- RECIPETITLE — VARCHAR2(100) — NOT NULL
- RECIPECONTENTS — CLOB — NOT NULL
- RECIPEINGREDIENTS — CLOB — NOT NULL
- RECIPEBASE — VARCHAR2(100) — NOT NULL
RECIPEIMG
- RECIPEIMGNUM — NUMBER
- RECIPENUM — NUMBER — Foreign key → RECIPE.RECIPENUM — NOT NULL
- IMGNAME — VARCHAR2(100) — NOT NULL
- ORIGINALNAME — VARCHAR2(100) — NOT NULL