1
Tables (12)
address
- dAdd_add — VARCHAR(50) — NOT NULL
- aAdd_phone — CHAR(11) — NOT NULL
- aAdd_type — ENUM('normal','cold') — NOT NULL
- member_id — BINARY(16) — Foreign key → member.member_id — NOT NULL
category
- category_id — INT
- category_name — CHAR(20) — NOT NULL
- category_detail — CHAR(20) — NOT NULL
coupon
- coupon_id — INT
- coupon_name — VARCHAR(20) — NOT NULL
- coupon_date — DATE — NOT NULL
- coupon_Edate — DATE — NOT NULL
- coupon_is_used — BOOL — NOT NULL
item
- item_id — INT
- item_name — CHAR(20) — NOT NULL
- item_explain — VARCHAR(30)
- item_detail — TEXT
- item_price — INT — NOT NULL
- item_img — LONGBLOB
- category_id — INT — Foreign key → category.category_id — NOT NULL
item_filter
- item_type — BOOL — NOT NULL
- item_price_level — ENUM('1000','10000','100000') — NOT NULL
- previle — SET('discount','limited','only')
- type — SET('kurlyonly','scacity','medical')
- certain_exeption — BOOL
- skin_type — SET('dry','complex','oily')
- hair_problem — SET('oiley','damaged','volume','scalp','dye')
- item_id — INT — Foreign key → item.item_id — NOT NULL
itemask
- itemask_id — INT
- itemask_date — DATETIME — NOT NULL
- itemask_status — BOOL
- itemask_ask — TEXT
- itemask_reply — TEXT
- itemask_replydate — DATETIME
- item_id — INT — Foreign key → item.item_id — NOT NULL
kurlylog
- kurlylog_id — INT
- kurlylog_date — DATE — NOT NULL
- kurlylog_text — TEXT — NOT NULL
- kurlylog_pic — LONGBLOB
- member_id — BINARY(16) — Foreign key → member.member_id — NOT NULL
- item_id — INT — Foreign key → item.item_id — NOT NULL
like
- like_id — INT
- member_id — BINARY(16) — Foreign key → member.member_id — NOT NULL
- item_id — INT — Foreign key → item.item_id — NOT NULL
member
- member_id — BINARY(16)
- member_name — VARCHAR(20) — NOT NULL
- member_password — CHAR(20) — NOT NULL
- member_email — VARCHAR(20) — NOT NULL
- member_date — DATE — NOT NULL
- member_gender — BOOL — NOT NULL
- member_birth — DATE — NOT NULL
- member_phone — CHAR(11) — NOT NULL
- member_address — VARCHAR(50) — NOT NULL
- member_14up — BOOL — NOT NULL
mileage
- mileage_name — VARCHAR(20)
- mileage_date — DATETIME
- mileage_Edate — DATE
- mileage_price — INT — NOT NULL
- member_id — BINARY(16) — Foreign key → member.member_id — NOT NULL
order
- order_id — BIGINT
- order_date — DATE — NOT NULL
- order_discount — INT
- order_price — INT — NOT NULL
- order_delivery — INT
- member_id — BINARY(16) — Foreign key → member.member_id — NOT NULL
- item_id — INT — Foreign key → item.item_id — NOT NULL
review
- review_id — INT
- review_title — VARCHAR(30) — NOT NULL
- review_info — TEXT
- review_img — LONGBLOB
- review_date — DATE — NOT NULL
- item_id — BIGINT — Foreign key → item.item_id — NOT NULL
- member_id — BINARY(16) — Foreign key → member.member_id — NOT NULL