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