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