sadsa
Tables (8)
OneOnOne
- one_no — number — Primary key — NOT NULL
- member_id — varchar2(20) — Foreign key → member.member_id — NOT NULL
- one_title — varchar2(100)
- one_content — varchar2(4000)
- one_date — date
- one_status — number
- one_category — varchar2(30)
Untitled
- qna_no — number — Primary key — NOT NULL
- qna_category — varchar2(30)
- qna_title — varchar2(100)
- qna_answer — varchar2(4000)
bascket
- bascket_no — number — Primary key — NOT NULL
- product_no — number — Foreign key → product.product_no — NOT NULL
- member_id — varchar2(20) — Foreign key → member.member_id — NOT NULL
- bascket_count — number
member
- member_id — varchar2(20) — Primary key — NOT NULL
- member_pw — varchar2(16)
- member_name — varchar2(21)
- member_email — varchr2(100)
- member_contact — char(11)
- member_post — varchar2(6)
- member_addr1 — varchar2(300)
- member_addr2 — varchar2(300)
- member_birth — char(10)
- member_point — number
- member_level — varchar2(9)
notice
- notice_no — number — Primary key — NOT NULL
- notice_title — varchar2(100)
- notice_writer — varchar2(9)
- notice_date — date
- notice_content — varchar2(4000)
payment
- payment_no — number — Primary key — NOT NULL
- product_no — number — Foreign key → product.product_no — NOT NULL
- member_id — varchar2(20) — Foreign key → member.member_id — NOT NULL
- payment_method — varchar2(15)
- payment_request — varchar2(100)
- payment_cancel — varchar2(30)
product
- product_no — number — Primary key — NOT NULL
- product_name — varchar2(900)
- product_price — number
- product_weight — number
- product_origin — varchar2(21)
- product_expire — char(10)
shopAfter
- shopAfter_no — number — Primary key — NOT NULL
- product_no — number — Foreign key → product.product_no — NOT NULL
- member_id — varchar2(20) — Foreign key → member.member_id — NOT NULL
- shopAfter_writer — varchar2(20)
- shopAfter_content — varchar2(4000)
- shopAfter_like — number
- shopAfter_date — date