amall
Tables (12)
CART
- cart_id — number(8) — Primary key — NOT NULL
- cart_quantity — number(5) — NOT NULL
- cart_regdate — DATE — NOT NULL
- cart_result — char(1) — NOT NULL — 전:1,후:2
- user_id — VARCHAR(20) — Foreign key → USER.user_id — NOT NULL
- prod_num — number(5) — Foreign key → PRODUCT.prod_num — NOT NULL
- cart_seq — SEQUENCE — NOT NULL
CATEGORY
- category_id — number(5) — Primary key — NOT NULL
- category_name — varchar(15) — NOT NULL
- category_seq — SEQUENCE — NOT NULL
MYPAGE
- user_id — VARCHAR(20) — Foreign key → USER.user_id — NOT NULL
- user_address — VARCHAR(200) — NOT NULL
- use_yn — number(1) — NOT NULL — 1:가입, 2:탈퇴
- match_yn — number(1) — NOT NULL — 1:연결됨,2:안됨
- recieve_review_num — number(5) — Foreign key → RECIEVEREVIEW.recieve_review_num
- order_review_num — number(5) — Foreign key → ORDERREVIEW.order_review_num
- qna_num — NUMBER(5) — Foreign key → QnA.qna_num — NOT NULL
ORDER
- order_num — number(5) — Primary key — NOT NULL
- order_date — DATE — NOT NULL
- order_name1 — VARCHAR(20) — NOT NULL
- order_phone1 — VARCHAR(20) — NOT NULL
- order_address1 — VARCHAR(200) — NOT NULL
- order_name2 — VARCHAR(20)
- order_phone2 — VARCHAR(20)
- order_address2 — VARCHAR(200)
- order_quantity — number(5) — NOT NULL
- order_card — number(1) — NOT NULL — 안함:1, 함:2
- order_letter — VARCHAR(200)
- order_request — VARCHAR(200)
- order_total — number(8) — NOT NULL
- order_result — number(1) — NOT NULL
- user_id — VARCHAR(20) — Foreign key → USER.user_id — NOT NULL
- prod_num — number(5) — Foreign key → PRODUCT.prod_num — NOT NULL
- cart_id — number(8) — Foreign key → CART.cart_id — NOT NULL
- order_seq — SEQUENCE — NOT NULL
ORDERREVIEW
- order_review_num — number(5) — Primary key — NOT NULL
- order_review_writer — varchar(20) — NOT NULL
- order_review_pwd — varchar(20) — NOT NULL
- order_review_title — varchar(100) — NOT NULL
- order_review_content — varchar(300) — NOT NULL
- order_review_image1 — BLOB
- order_review_image2 — BLOB
- order_review_show — number(1) — NOT NULL — 1: 보임,2:안보임
- prod_num — number(5) — Foreign key → PRODUCT.prod_num — NOT NULL
- order_num — number(5) — Foreign key → ORDER.order_num — NOT NULL
- order_review_seq — SEQUENCE — NOT NULL
PRODUCT
- prod_num — number(5) — Primary key — NOT NULL
- prod_name — varchar(100) — NOT NULL — UI
- prod_price — number(10) — NOT NULL — UI
- prod_stock — number(10) — NOT NULL — UI
- prod_explanation — varchar(1000) — NOT NULL — UI
- prod_regdate — DATE — NOT NULL
- prod_hit — number(10) — NOT NULL — UI
- prod_detail — varchar2(4000) — NOT NULL — UI
- prod_image1 — BLOB — NOT NULL — UI
- prod_image2 — BLOB — UI
- prod_image3 — BLOB — UI
- prod_size — CHAR(4) — NOT NULL — UI
- prod_color — CHAR(2) — NOT NULL — UI
- prod_deliveryfee — CHAR(5) — NOT NULL — UI
- prod_star — number(1) — NOT NULL
- prod_show — number(1) — NOT NULL
- seller_id — varchar(20) — Foreign key → SELLER.seller_id — NOT NULL
- category_id — number(5) — Foreign key → CATEGORY.category_id — NOT NULL
- product_seq — SEQUENCE — NOT NULL
QnA
- qna_num — NUMBER(5) — Primary key — NOT NULL
- qna_title — varchar(20) — NOT NULL
- qna_content — varchar(400) — NOT NULL
- qna_date — DATE — NOT NULL
- qna_reply — varchar(400)
- qna_replyexist — number(1) — NOT NULL — 전 : 1, 후 :2
- prod_num — NUMBER(5) — Foreign key → PRODUCT.prod_num — NOT NULL
- user_id — VARCHAR(20) — Foreign key → USER.user_id — NOT NULL
- qna_seq — SEQUENCE — NOT NULL
RECIEVEREVIEW
- recieve_review_num — number(5) — Primary key — NOT NULL
- order_num — number(5) — Foreign key → ORDER.order_num — NOT NULL
- prod_num — number(5) — Foreign key → PRODUCT.prod_num — NOT NULL
- recieve_review_writer — varchar(20) — NOT NULL
- recieve_review_pwd — varchar(20) — NOT NULL
- recieve_review_title — varchar(100) — NOT NULL
- recieve_review_content — varchar(300) — NOT NULL
- recieve_review_image1 — BLOB
- recieve_review_image2 — BLOB
- recieve_review_star — number(1)
- order_review_seq — SEQUENCE — NOT NULL
SELLER
- seller_id — varchar(20) — Primary key — NOT NULL
- seller_pwd — varchar(20) — NOT NULL
- seller_name — varchar(20) — NOT NULL
- seller_revenue — number(20) — NOT NULL
USER
- user_id — VARCHAR(20) — Primary key — NOT NULL
- user_name — VARCHAR(20) — NOT NULL
- user_birth — VARCHAR(10) — NOT NULL
- user_pwd — VARCHAR(20) — NOT NULL
- user_email — VARCHAR(40) — NOT NULL
- user_phone — VARCHAR(20) — NOT NULL
- user_sex — number(1) — NOT NULL — 1: 남자, 2: 여자
- user_regdate — DATE — NOT NULL
- user_connectdate — DATE — NOT NULL
- user_hash — VARCHAR2(4000) — NOT NULL — 유저 매칭용 코드
- user_matchid — VARCHAR(20) — 매칭된 유저 ID
- user_matchname — VARCHAR(20)
WISHLIST
- wishlist_id — VARCHAR(255) — Primary key — NOT NULL
- wishlist_show — number(1) — NOT NULL — 1:보임,2:안보임
- wishlist_regdate — DATE — NOT NULL
- user_id — VARCHAR(20) — Foreign key → USER.user_id — NOT NULL
- prod_num — number(5) — Foreign key → PRODUCT.prod_num — NOT NULL
- wishlist_seq — SEQUENCE — NOT NULL
admin
- admin_id — varchar(20) — Primary key — NOT NULL
- admin_name — varchar(20) — NOT NULL
- admin_pwd — varchar(20) — NOT NULL
- admin_email — varchar(40) — NOT NULL
- admin_phone — varchar(20) — NOT NULL
- seller_id — varchar(20) — Foreign key → SELLER.seller_id — NOT NULL
- user_id — VARCHAR(20) — Foreign key → USER.user_id — NOT NULL