구독플랫폼

테이블 (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)