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