postgreSQL 버전

테이블 (17)

addon_spec

  • id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → product.id — NOT NULL
  • unit_type — unit_type_enum — NOT NULL
  • unit_price_amount — DECIMAL(18, 0) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

bill

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • billing_yyyymm — VARCHAR(6) — NOT NULL
  • total_amount — DECIMAL(18, 0) — NOT NULL
  • vat — DECIMAL(18, 0) — NOT NULL
  • unpaid_amount — DECIMAL(18, 0) — NOT NULL
  • total_discount_amount — DECIMAL(18, 0) — NOT NULL
  • total_billed_amount — DECIMAL(18, 0) — NOT NULL
  • due_date — DATE
  • approval_expected_date — DATE
  • bill_send_status — bill_send_status_enum
  • payment_owner_name_snapshot — VARCHAR(100) — NOT NULL
  • payment_name_snapshot — VARCHAR(100) — NOT NULL
  • payment_number_snapshot — VARCHAR(100) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

bill_item

  • id — BIGINT — 기본 키 — NOT NULL
  • bill_id — BIGINT — 외래 키 → bill.id — NOT NULL
  • item_category — bill_item_category_enum — NOT NULL
  • item_subcategory — bill_item_subcategory_enum
  • item_name — VARCHAR(255) — NOT NULL
  • amount — DECIMAL(18, 0) — NOT NULL
  • detail_snapshot — JSONB
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

bill_notification

  • id — BIGINT — 기본 키 — NOT NULL
  • bill_id — BIGINT — 외래 키 → bill.id — NOT NULL
  • channel — bill_channel_enum — NOT NULL
  • send_status — bill_notification_status_enum — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

device

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price — DECIMAL(18, 0) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

discount_policy

  • id — BIGINT — 기본 키 — NOT NULL
  • discount_name — VARCHAR(255) — NOT NULL
  • discount_type — discount_type_enum — NOT NULL
  • discount_method — discount_method_enum — NOT NULL
  • discount_value — DECIMAL(18, 6) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

member

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • member_grade — member_grade_enum — NOT NULL
  • payment_owner_name — VARCHAR(100) — NOT NULL
  • payment_name — VARCHAR(100) — NOT NULL
  • payment_number — VARCHAR(100) — NOT NULL
  • payment_method — payment_method_enum — NOT NULL
  • notification_day_of_month — SMALLINT
  • do_not_disturb_start_time — TIME
  • do_not_disturb_end_time — TIME
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

member_device

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • device_id — BIGINT — 외래 키 → device.id — NOT NULL
  • purchase_price — DECIMAL(18, 0) — NOT NULL
  • installment_months — SMALLINT — NOT NULL
  • purchased_at — TIMESTAMP — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

mobile_plan_spec

  • id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → product.id — NOT NULL
  • data_gb — DECIMAL(10, 3)
  • voice_minutes — INTEGER
  • sms_count — INTEGER
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

one_time_purchase

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • amount — DECIMAL(18, 0) — NOT NULL
  • charge_type — charge_type_enum — NOT NULL
  • charged_at — TIMESTAMP — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

product

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price_amount — DECIMAL(18, 0) — NOT NULL
  • billing_type — billing_type_enum — NOT NULL
  • product_type — product_type_enum — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

receipt

  • id — BIGINT — 기본 키 — NOT NULL
  • bill_id — BIGINT — 외래 키 → bill.id — NOT NULL
  • paid_at — TIMESTAMP — NOT NULL
  • payment_method — payment_method_enum — NOT NULL
  • paid_amount — DECIMAL(18, 0) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

reservation_notification

  • id — BIGINT — 기본 키 — NOT NULL
  • target_billing_yyyymm — VARCHAR(6) — NOT NULL
  • scheduled_send_at — TIMESTAMP — NOT NULL
  • reservation_status — reservation_status_enum — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

subscription

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • product_id — BIGINT — 외래 키 → product.id — NOT NULL
  • subscription_status — subscription_status_enum — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

subscription_discount

  • id — BIGINT — 기본 키 — NOT NULL
  • discount_policy_id — BIGINT — 외래 키 → discount_policy.id — NOT NULL
  • subscription_id — BIGINT — 외래 키 → subscription.id — NOT NULL
  • contract_start_date — DATE
  • contract_end_date — DATE
  • contract_status — contract_status_enum — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

subscription_usage

  • id — BIGINT — 기본 키 — NOT NULL
  • subscription_id — BIGINT — 외래 키 → subscription.id — NOT NULL
  • usage_yyyymm — VARCHAR(6) — NOT NULL
  • usage_type — usage_type_enum — NOT NULL
  • quantity — DECIMAL(18, 3) — NOT NULL
  • unit_type — unit_type_enum — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL

tv_spec

  • id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → product.id — NOT NULL
  • channel_count — INTEGER — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — status_enum — NOT NULL