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