benepicker

Tables (14)

benefit

  • benefit_id — BIGINT
  • store_id — BIGINT — Foreign key → store.store_id — NOT NULL
  • benefit_type — VARCHAR(20) — NOT NULL
  • benefit_content — VARCHAR(500)
  • benefit_discount — INT
  • benefit_condition — VARCHAR(200)
  • start_date — DATE
  • end_date — DATE
  • created_date — DATETIME

benefit_use

  • use_id — BIGINT
  • member_no — BIGINT — Foreign key → member.member_no — NOT NULL
  • benefit_id — BIGINT — Foreign key → benefit.benefit_id — NOT NULL
  • use_date — DATETIME
  • discount_amount — INT
  • rating — TINYINT
  • review_content — VARCHAR(500)

brand

  • brand_id — BIGINT
  • brand_name — VARCHAR(100) — NOT NULL
  • brand_image_url — VARCHAR(300)

brand_alert

  • alert_id — BIGINT
  • member_no — BIGINT — Foreign key → member.member_no — NOT NULL
  • brand_id — BIGINT — Foreign key → brand.brand_id — NOT NULL
  • created_date — DATETIME

card

  • card_id — BIGINT
  • card_company — VARCHAR(100) — NOT NULL
  • card_name — VARCHAR(100) — NOT NULL
  • is_linked — CHAR(1)

faq

  • faq_id — BIGINT
  • faq_question — VARCHAR(500) — NOT NULL
  • faq_answer — TEXT
  • created_date — DATETIME

inquiry

  • inquiry_id — BIGINT
  • member_no — BIGINT — Foreign key → member.member_no — NOT NULL
  • inquiry_title — VARCHAR(200) — NOT NULL
  • inquiry_content — TEXT — NOT NULL
  • answer_content — TEXT
  • status — VARCHAR(20)
  • created_date — DATETIME
  • answered_date — DATETIME

member

  • member_no — BIGINT
  • member_email — VARCHAR(100)
  • member_pw — VARCHAR(100) — NOT NULL
  • member_nickname — VARCHAR(50) — NOT NULL
  • member_tel — VARCHAR(20)
  • enroll_date — DATETIME
  • member_del_fl — CHAR(1)

member_barcode

  • barcode_id — BIGINT
  • member_no — BIGINT — Foreign key → member.member_no — NOT NULL
  • barcode_type — VARCHAR(20) — NOT NULL
  • store_name — VARCHAR(100)
  • barcode_image_url — VARCHAR(300)
  • created_date — DATETIME

member_card

  • member_card_id — BIGINT
  • member_no — BIGINT — Foreign key → member.member_no — NOT NULL
  • card_id — BIGINT — Foreign key → card.card_id — NOT NULL
  • registered_date — DATETIME

member_goal

  • goal_id — BIGINT
  • member_no — BIGINT — Foreign key → member.member_no — NOT NULL
  • goal_year — SMALLINT — NOT NULL
  • goal_month — TINYINT — NOT NULL
  • goal_amount — INT

search_history

  • search_id — BIGINT
  • member_no — BIGINT — Foreign key → member.member_no — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL
  • search_date — DATETIME

store

  • store_id — BIGINT
  • store_name — VARCHAR(100) — NOT NULL
  • store_address — VARCHAR(200)
  • store_lat — DECIMAL(10,7)
  • store_lng — DECIMAL(10,7)
  • store_image_url — VARCHAR(300)
  • store_logo_url — VARCHAR(300)
  • store_app_link — VARCHAR(300)
  • brand_id — BIGINT — Foreign key → brand.brand_id
  • view_count — INT
  • created_date — DATETIME

wish

  • wish_id — BIGINT
  • member_no — BIGINT — Foreign key → member.member_no — NOT NULL
  • store_id — BIGINT — Foreign key → store.store_id
  • brand_id — BIGINT — Foreign key → brand.brand_id
  • wish_type — VARCHAR(10) — NOT NULL
  • wish_date — DATETIME
  • alert_fl — CHAR(1)