common
테이블 (5)
subscription (구독정보내역)
- subscription_id (PK) — bigint — 기본 키 — NOT NULL
- sub_info_id (PK2) — 외래 키 → subscription_info.sub_info_id — NOT NULL
- sub_name (Field) — varchar(20)
- billing_cycle (Field3) — ENUM('월', '연')
- start_date (Field5) — DATE
- next_payment_date (Field6) — DATE
- card_type (Field7) — varcar(20)
- status (Field8) — ENUM('구독 중', '해지')
- oauth_id (Key) — bigint — 외래 키 → 사용자.id — NOT NULL
- amount_krw (Field2) — bigint
- total_preiod (Field4) — DATE
subscription_history (구독내역)
- subscriprion_history_id (PK) — bigint — 기본 키 — NOT NULL
- subscription_id (PK2) — bigint — 외래 키 → subscription.subscription_id — NOT NULL
- sub_info_id (PK22) — 외래 키 → subscription.sub_info_id — NOT NULL
- payment_date (Field2) — DATE
- amount_krw (Field3) — int
- amount_usd (Field4) — DECIMAL(10, 2)
- total_period (Field5) — DATE
subscription_info (구독정보)
- sub_info_id (PK) — 기본 키 — NOT NULL
- sub_info_name (Field) — varchar(20)
- sub_info_logo_url (Field2) — varchar(250)
- sub_price (Field3) — int
- sub_level (Field4) — varchar(20)
사용자 (user)
- id (Key) — bigInt — 기본 키 — NOT NULL
- oauth_id (Field) — bigint
- nickname (Field2) — varchar(20)
- profile_url (Field3) — varchar(250)
- created_at (Field4) — timestamp
- update_at (Field5) — timestamp
- phone_number (Field6) — varchar(20)
- login_ip_addr (Field7) — varchar(20)
- oauth_domain (Field8) — varchar(20)
- user_level (Field9) — ENUM('USER', 'ADMIN')
연봉계산테이블 (salray_tax_table)
- id (Key) — bigint — 기본 키 — NOT NULL
- annual_salary (Field) — bigint
- net_monthly (Field2) — bigint
- deduction_total (Field3) — bigint
- pension (Field4) — bigint
- health (Field5) — bigint
- long_term_care (Field6) — bigint
- employment (Field7) — bigint
- income_tax (Field8) — bigint
- long_tax (Field9) — bigint
- year (Field10) — int