Dango ERD

Tables (9)

coupon_bookmarks

  • id — BIGSERIAL
  • device_id — VARCHAR(255) — NOT NULL
  • template_id — BIGINT — Foreign key → coupon_templates.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

coupon_instances

  • id — BIGSERIAL
  • device_id — VARCHAR(255) — NOT NULL
  • coupon_issue_id — BIGINT — Foreign key → coupon_issues.id — NOT NULL
  • store_id — BIGINT — Foreign key → stores.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • amount — BIGINT — NOT NULL
  • start_datetime — TIMESTAMP — NOT NULL
  • end_datetime — TIMESTAMP — NOT NULL
  • is_all_day — BOOLEAN
  • status — VARCHAR(50) — NOT NULL
  • used_at — TIMESTAMP
  • expired_at — TIMESTAMP
  • action_type — VARCHAR(50)

coupon_issues

  • id — BIGSERIAL
  • coupon_template_id — BIGINT — Foreign key → recurring_coupon_templates.template_id — NOT NULL
  • issue_no — INTEGER — NOT NULL
  • store_id — BIGINT — Foreign key → stores.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • amount — BIGINT — NOT NULL
  • start_datetime — TIMESTAMP — NOT NULL
  • end_datetime — TIMESTAMP — NOT NULL
  • is_all_day — BOOLEAN

coupon_logs

  • id — BIGSERIAL
  • action_type — VARCHAR(50) — NOT NULL
  • coupon_instance_id — BIGINT
  • coupon_issue_id — BIGINT
  • log_time — TIMESTAMP — NOT NULL

coupon_templates

  • id — BIGSERIAL
  • store_id — BIGINT — Foreign key → stores.id — NOT NULL
  • coupon_type — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • expired_at — TIMESTAMP

coupon_usage

  • id — BIGSERIAL
  • instance_id — BIGINT — Foreign key → coupon_instances.id — NOT NULL
  • store_id — BIGINT — Foreign key → stores.id — NOT NULL
  • device_id — VARCHAR(255)
  • used_at — TIMESTAMP — NOT NULL
  • verified_by_staff — BOOLEAN

merchants

  • user_id — BIGINT
  • business_name — VARCHAR(255) — NOT NULL
  • representative_name — VARCHAR(255)
  • business_registration_number — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

recurring_coupon_templates

  • template_id — BIGINT — Foreign key → coupon_templates.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • amount — BIGINT — NOT NULL
  • recurrence_type — VARCHAR(50) — NOT NULL
  • day_of_week — INTEGER
  • start_time — TIME
  • end_time — TIME
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • interval — INTEGER

stores

  • id — BIGSERIAL
  • merchant_id — BIGINT — Foreign key → merchants.user_id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255)
  • thumb_image_url — VARCHAR(255)
  • menu_image_url — VARCHAR(255)
  • naver_map_url — VARCHAR(255)
  • kakao_map_url — VARCHAR(255)
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL