meokqV2

Tables (16)

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_auth

    tb_boss

    • email — varchar(20)
    • nickname — varchar(20)
    • status — varchar(10)
    • position — varchar(20)
    • create_date — timestamp
    • update_date — timestamp

    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(10) — Foreign key → tb_customer.email — NOT NULL
    • email — varchar(20) — Foreign key → tb_quest.email

    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

    tb_customer

    • email — varchar(255) — Primary key — NOT NULL
    • status — varchar(10)
    • create_date — timestamp
    • update_date — timestamp
    • nickname — varchar(20)

    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)
    • email — varchar(20) — Foreign key → tb_boss.email

    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)

    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
    • email — varchar(20) — Foreign key → tb_market.email
    • reward_id (Key) — Foreign key → tb_reward.reward_id — NOT NULL
    • mission_id — varchar(255) — Foreign key → tb_mission.mission_id — NOT NULL

    tb_reward

    • reward_id (Key) — 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)

    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)