4
Tables (13)
ANSWER
- qna_id — VARCHAR(20) — NOT NULL
- answer_member_id — VARCHAR(20) — NOT NULL
- status — VARCHAR(1) — NOT NULL
- answer_content — TEXT
- status_date — DATETIME
- last_edit_date — DATETIME — NOT NULL
CART
- member_id — VARCHAR(20) — Primary key — NOT NULL
- product_id — VARCHAR(20) — Primary key — NOT NULL
- cart_add_date — DATETIME — NOT NULL
CATEGORY
- category_id — VARCHAR(20) — NOT NULL
- category_name — VARCHAR(20) — NOT NULL
- parent_id — VARCHAR(20)
COUPON
- coupon_id — VARCHAR(20) — NOT NULL
- issued_by_member_id — VARCHAR(20) — NOT NULL
- discount_price — INT — NOT NULL
- end_date — DATETIME — NOT NULL
- last_edit_date — DATETIME — NOT NULL
LICENSE
- product_id — VARCHAR(20) — Primary key — NOT NULL
- member_id — VARCHAR(20) — Primary key — NOT NULL
- expire_date — DATETIME — NOT NULL
MEMBER
- member_id — VARCHAR(20) — NOT NULL
- email — VARCHAR(40) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- is_admin — BOOLEAN — NOT NULL
- register_date — DATETIME — NOT NULL
MEMBER_COUPON
- member_coupon_id — VARCHAR(20) — NOT NULL
- member_id — VARCHAR(20) — NOT NULL
- coupon_id — VARCHAR(20) — NOT NULL
- use_date — DATETIME
- issued_date — DATETIME — NOT NULL
ORDER_DETAIL
- order_id — VARCHAR(20) — Primary key — NOT NULL
- product_id — VARCHAR(20) — Primary key — NOT NULL
ORDER_LIST
- order_id — VARCHAR(20) — NOT NULL
- member_id — VARCHAR(20) — NOT NULL
- member_coupon_id — VARCHAR(20)
- last_order_price — INT — NOT NULL
- order_date — DATETIME — NOT NULL
PRODUCT
- product_id — VARCHAR(20) — NOT NULL
- category_id — VARCHAR(20) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- price — INT — NOT NULL
- end_date — DATETIME — NOT NULL
- version — VARCHAR(10) — NOT NULL
- last_edit_date — DATETIME — NOT NULL
- expire_date — DATETIME
QUESTION
- qna_id — VARCHAR(20) — NOT NULL
- member_id — VARCHAR(20) — NOT NULL
- title — VARCHAR(300) — NOT NULL
- content — TEXT — NOT NULL
- last_edit_date — DATETIME — NOT NULL
REVIEW
- product_id — VARCHAR(20) — Primary key — NOT NULL
- member_id — VARCHAR(20) — Primary key — NOT NULL
- content — TEXT
- rate — INT — NOT NULL
- last_edit_date — DATETIME — NOT NULL
WISHLIST
- product_id — VARCHAR(20) — Primary key — NOT NULL
- member_id — VARCHAR(20) — Primary key — NOT NULL
- wishlist_add_date — DATETIME — NOT NULL