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)