구독플랫폼
테이블 (13)
board
- board_id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- content — text
- cypher — varchar(255)
- title — varchar(120)
- views — int(11)
- created_by — bigint(20) — 외래 키 → member.member_id
- modified_by — bigint(20) — 외래 키 → member.member_id
- show — varchar(100)
- country — varchar(100)
- file_master_id — bigint(20) — 외래 키 → file_master.file_master_id
cancel_history
- cancel_history_id — bigint(20) — 기본 키 — NOT NULL
- cancel_reason — varchar(5000) — NOT NULL
- canceled_at — datetime(6) — NOT NULL
- subscribe_id — bigint(20) — 외래 키 → subscribe.subscribe_id — NOT NULL
comment
- comment_id — bigint(20) — 기본 키 — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- content — varchar(255)
- created_by — bigint(20) — 외래 키 → member.member_id
- modified_by — bigint(20) — 외래 키 → member.member_id
- board_id — bigint(20) — 외래 키 → board.board_id
dashboard
- dashboard_id — bigint(20) — 기본 키 — NOT NULL
- assigned_at — datetime(6) — NOT NULL
- member_id — bigint(20) — 외래 키 → member.member_id — NOT NULL
- serial_id — bigint(20) — 외래 키 → serial.serial_id — NOT NULL
- subscribe_id — bigint(20) — 외래 키 → subscribe.subscribe_id — NOT NULL
file_detail
- file_detail_id — bigint(20) — 기본 키 — NOT NULL
- extension — varchar(255)
- file_name — varchar(255)
- file_path — varchar(255)
- file_size — bigint(20)
- origin_file_name — varchar(255)
- file_master_id — bigint(20) — 외래 키 → file_master.file_master_id
file_master
- file_master_id — bigint(20) — 기본 키 — NOT NULL
- category — enum('SUBSCRIBE_PICTURE','SUBSCRIBE_BOARD')
log
- log_id — bigint(20) — 기본 키 — NOT NULL
- access_ip — varchar(255)
- is_login_success — varchar(255)
- login_time — datetime(6)
- member_id — bigint(20) — 외래 키 → member.member_id
member
- member_id — bigint(20) — 기본 키 — NOT NULL
- country — varchar(255)
- created_at — datetime(6)
- customer — varchar(255)
- login_id — varchar(255)
- password — varchar(255)
- password_updated_at — datetime(6)
- platform_agree — varchar(255)
- privacy_agree — varchar(255)
- agree_at — datetime(6)
- member_authority — enum('ADMIN','USER')
- customer_id — varchar(30)
payment_history
- payment_history_id — bigint(20) — 기본 키 — NOT NULL
- billing_key — varchar(255)
- customer_key — varchar(255) — Toss customerKey (회원 식별자)
- receipt_url — varchar(500)
- fail_reason — varchar(255)
- paid_at — datetime(6) — NOT NULL
- payment_method — varchar(255) — NOT NULL
- payment_status — varchar(255) — NOT NULL
- subscribe_id — bigint(20) — 외래 키 → subscribe.subscribe_id — NOT NULL
- order_id — varchar(255) — NOT NULL
- payment_key — varchar(255) — NOT NULL
- amount — bigint(20) — NOT NULL
- currency — varchar(10) — NOT NULL
product_prices
- price_id — bigint(20) — 기본 키 — NOT NULL
- product_id — bigint(20) — 외래 키 → products.product_id — NOT NULL
- country_code — enum('KR','US','JP') — NOT NULL
- plan — enum('M','A') — NOT NULL
- price — decimal(10,2) — NOT NULL
- discount_rate — decimal(5,2)
products
- product_id — bigint(20) — 기본 키 — NOT NULL
- name — varchar(255) — NOT NULL
- subtitle — varchar(1000)
- description — text
- status — enum('판매예정','판매진행','서비스종료') — NOT NULL
- created_by_id — bigint(20) — 외래 키 → member.member_id
- modified_by_id — bigint(20) — 외래 키 → member.member_id
- created_at — timestamp
- updated_at — timestamp
- file_master_id — bigint(20) — 외래 키 → file_master.file_master_id
serial
- serial_id — bigint(20) — 기본 키 — NOT NULL
- serial_number — varchar(255) — NOT NULL
- member_id — bigint(20) — 외래 키 → member.member_id
- model_name — varchar(50)
subscribe
- subscribe_id — bigint(20) — 기본 키 — NOT NULL
- agree_payment — varchar(255) — NOT NULL
- agree_terms — varchar(255) — NOT NULL
- buyer — varchar(255)
- created_at — datetime(6) — NOT NULL
- invoice_email — varchar(255)
- payment_method — varchar(255) — NOT NULL
- price — bigint(20) — NOT NULL
- member_id — bigint(20) — 외래 키 → member.member_id — NOT NULL
- product_id — bigint(20) — 외래 키 → products.product_id — NOT NULL
- product_price_id — bigint(20) — 외래 키 → product_prices.price_id — NOT NULL
- subscribe_status — varchar(255) — NOT NULL
- billing_key — varchar(255)
- customer_key — varchar(255) — Toss customerKey (회원 식별자)
- is_recurring — varchar(255)
- last_paid_date — datetime(6)
- next_payment_date — datetime(6)
- used_at — datetime(6)