ourHm

Tables (12)

CART (장바구니)

  • Key (CART_NO) — NUMBER — Primary key — NOT NULL
  • Field (OPTION_NO) — NUMBER
  • 유저아이디 (USER_ID) — VARCHAR2(30)
  • Field3 (AMOUNT) — NUMBER
  • Field4 (PRICE) — NUMBER

CATEGORY (Untitled)

  • Key (CATEGORY_NO) — NUMBER — Primary key — NOT NULL
  • Field (CATEGORY_NAME) — VARCHAR2(20)

COMMENTS (Untitled2)

  • Key (COMMENT_IDX) — NUMBER(6) — Primary key — NOT NULL
  • Field (WRITER) — VARCHAR2(30)
  • Field (CONTENT) — VARCHAR2(4000)
  • Field (PWD) — VARCHAR2(20)
  • Field (WRITE_DATE) — DATE
  • Field (IP) — VARCHAR2(15)
  • Field (BBS_IDX) — NUMBER(6)

DELADDR (Untitled3)

  • Key (DEL_NO) — NUMBER — Primary key — NOT NULL
  • Field (DEL_NAME) — VARCHAR2(30)
  • Field (DEL_GETTER) — VARCHAR2(30)
  • Field (DEL_PHONE) — VARCHAR2(30)
  • Field (DEL_ADDR) — VARCHAR2(30)
  • Field (USER_NO) — NUMBER

LIKE_PRODUCT (Untitled4)

  • Key (LIKE_NO) — NUMBER — Primary key — NOT NULL
  • Field (PRODUCT_NO) — NUMBER
  • Field (USER_ID) — VARCHAR2(30)
  • Field (LDATE) — DATE

ORDER_DETAIL (Untitled5)

  • Key (ORDER_DETAIL_KEY) — VARCHAR2(30) — Primary key — NOT NULL
  • Field (ORDER_NO) — NUMBER(10)
  • Field (PRODUCT_NO) — NUMBER(30)
  • Field (AMOUNT) — NUMBER
  • Field (TOTAL_PRICE) — NUMBER
  • Field (ORDER_STATUS) — VARCHAR2(20)
  • Field (ORDER_DATE) — VARCHAR2(20)
  • Field (OPTION_SIZE) — VARCHAR2(20)

ORDER_MAIN (Untitled6)

  • Key (ORDER_NO) — NUMBER(10) — Primary key — NOT NULL
  • Field (USER_ID) — VARCHAR2(30)

PRODUCT (Untitled7)

  • Key (PRODUCT_NO) — NUMBER — Primary key — NOT NULL
  • Field (PRODUCT_NAME) — VARCHAR2(300)
  • Field (PRICE) — NUMBER
  • Field2 (CATEGORY_NO) — NUMBER
  • Field (THUMNAIL) — VARCHAR2(30)
  • Field (ORIGINAL_IMG) — VARCHAR2(30)
  • Field (RATE) — NUMBER
  • Field (CONTENT) — VARCHAR2(3000)

PRODUCT_OPTION (Untitled8)

  • Key (OPTION_NO) — NUMBER — Primary key — NOT NULL
  • Field (PRODUCT_NO) — NUMBER
  • Field (OPTION_SIZE) — VARCHAR2(10)
  • Field2 (OPTION_COUNT) — VARCHAR2(10)

QA (Untitled9)

  • Key (QNA_NO) — NUMBER(20) — Primary key — NOT NULL
  • Field (TITLE) — VARCHAR2(2000)
  • Field (CONTENT) — VARCHAR2(2000)
  • Field (USER_ID) — VARCHAR2(20)
  • Field (USER_NAME) — VARCHAR2(20)
  • Field (WDATE) — DATE
  • Field (PRODUCT_NO) — NUMBER
  • Field (HIT) — NUMBER

REVIEW (Untitled10)

  • Key (REVIEW_NO) — NUMBER(20) — Primary key — NOT NULL
  • Field (TITLE) — VARCHAR(2000)
  • Field (CONTENT) — VARCHAR(2000)
  • Field (USER_ID) — VARCHAR(20)
  • Field (USER_NAME) — VARCHAR(20)
  • Field (WDATE) — DATE
  • Field (PRODUCT_NO) — NUMBER
  • Field (HIT) — NUMBER
  • Field (REVIEW_IMG) — VARCHAR2(200)

USERS (Untitled11)

  • 유저번호 (USER_NO) — NUMBER — Primary key — NOT NULL
  • 유저아이디 (USER_ID) — VARCHAR2(30)
  • 비밀번호 (PWD) — VARCHAR2(30)
  • 이름 (NAME) — VARCHAR2(30)
  • 폰번호 (PHONE) — VARCHAR2(30)
  • 이메일 (EMAIL) — VARCHAR2(30)
  • 주소 (ADDRESS) — VARCHAR2(30)
  • Field (DEL_NO) — NUMBER