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