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