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)