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