meokq-db01
Tables (15)
tb_admin
- admin_id — varchar(10) — Primary key — NOT NULL
- status — varchar(10)
- delete_yn — varchar(1)
- create_date — timestamp
- update_date — timestamp
- nickname — VARCHAR(255)
tb_boss
- boss_id — VARCHAR(255) — Primary key — NOT NULL
- nickname — varchar(20)
- status — varchar(10)
- position — varchar(20)
- create_date — timestamp
- update_date — timestamp
- email — varchar(20)
tb_challenge_history
- challenge_id — varchar(255) — Primary key — NOT NULL
- create_date — timestamp
- update_date — timestamp
- receipt_image_id — varchar(255)
- status — varchar(20)
- reject_reason — VARCHAR(255)
- quest_id — varchar(10) — Foreign key → tb_quest.quest_id — NOT NULL
- customer_id — VARCHAR(255) — Foreign key → tb_customer.customer_id — NOT NULL
tb_coupon
- coupon_id — varchar(255) — Primary key — NOT NULL
- status — varchar(10)
- create_date — timestamp
- update_date — timestamp
- use_date — timestamp
- expiry_date — timesatmp
- challenge_id — varchar(255) — Foreign key → tb_challenge_history.challenge_id — NOT NULL
- reward_id — varchar(255) — Foreign key → tb_reward.reward_id — NOT NULL
- quest_id — varchar(10) — Foreign key → tb_quest.quest_id — NOT NULL
- customer_id — VARCHAR(255) — Foreign key → tb_customer.customer_id — NOT NULL
- market_id — varchar(10) — Foreign key → tb_market.market_id — NOT NULL
tb_customer
- customer_id — VARCHAR(255) — Primary key — NOT NULL
- status — varchar(10)
- create_date — timestamp
- update_date — timestamp
- nickname — varchar(20)
- email — varchar(255) — NOT NULL
tb_image
- image_id — varchar(10) — Primary key — NOT NULL
- location — varchar(255)
- 이미지 — 크기`
tb_market
- market_id — varchar(10) — Primary key — NOT NULL
- name — varchar(255)
- address — varchar(255)
- district — varchar(10)
- content — varchar(255)
- phone — varchar(20)
- ticket_count — int(11)
- delete_yn — varchar(1)
- create_date — timestamp
- update_date — timestamp
- logo_image_id — varchar(255)
- status — varchar(255)
- represent_id — VARCHAR(255) — Foreign key → tb_boss.boss_id — NOT NULL
tb_market_time
- market_id — varchar(10) — Foreign key → tb_market.market_id — NOT NULL
- week_day — varchar(3)
- open_time — time
- close_time — time
- holiday_yn — varchar(1)
- create_date — timestamp
- update_date — timestamp
tb_mission
- mission_id — varchar(255) — Primary key — NOT NULL
- delete_yn — varchar(1)
- create_date — timestamp
- update_date — timestamp
- quantity — int(11)
- target — varchar(20)
- content — varchar(255)
- quest_id — varchar(10) — Foreign key → tb_quest.quest_id — NOT NULL
tb_notice
- notice_id — varchar(10) — Primary key — NOT NULL
- delete_yn — varchar(1)
- create_date — timestamp
- update_date — timestamp
- title — varchar(255)
- content — varchar(255)
- target — varchar(20)
tb_notice_image
- image_id — varchar(10) — Primary key — NOT NULL
- notice_id — varchar(10) — Foreign key → tb_notice.notice_id — NOT NULL
- image_url — varchar(255)
- delete_yn — varchar(1)
- create_date — timestamp
- update_date — timestamp
- type — varchar(20)
tb_quest
- quest_id — varchar(10) — Primary key — NOT NULL
- create_date — timestamp
- update_date — timestamp
- status — varchar(10)
- market_id — varchar(10) — Foreign key → tb_market.market_id — NOT NULL
tb_reward
- reward_id — varchar(255) — Primary key — NOT NULL
- delete_yn — varchar(1)
- create_date — timestamp
- update_date — timestamp
- quantity — int(11)
- discount_rate — int(3)
- content — varchar(255)
- target — varchar(20)
- Field — VARCHAR(255)
- quest_id — varchar(10) — Foreign key → tb_quest.quest_id — NOT NULL
tb_system_code
- code_id — varchar(10) — Primary key — NOT NULL
- group_id — varchar(10) — Foreign key → tb_system_group_code.group_id — NOT NULL
- delete_yn — varchar(1)
- create_date — timestamp
- update_date — timestamp
- name — varchar(20)
- note — varchar(255)
tb_system_group_code
- group_id — varchar(10) — Primary key — NOT NULL
- delete_yn — varchar(1)
- create_date — timestamp
- update_date — timestamp
- name — varchar(20)
- note — varchar(255)