test

Tables (10)

cloud_product (Untitled11)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • name (Field) — varchar(50)
  • created_at (Field2) — date
  • updated_at (Field3) — date

exchange_rate_per_month (Untitled9)

  • id (Key) — long — Primary key — NOT NULL
  • applied_date (Key2) — date — Primary key — NOT NULL
  • exchagne_rate (Field2) — float
  • exchange_price_krw (Field3) — float
  • exchange_price_usd (Field4) — float

use_amount_per_month(or day) (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • product_id (Key2) — bigint — Foreign key → cloud_product.id — NOT NULL
  • user_id (Key22) — bigint — Foreign key → cloud_product.user_id — NOT NULL
  • total_use_amount (Field2) — float
  • date (Field3) — date

use_total_amount_per_product (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • product_id (Key3) — bigint — Foreign key → cloud_product.id — NOT NULL
  • user_id (Key22) — bigint — Foreign key → cloud_product.user_id — NOT NULL
  • use_amount_usd (Field3) — float
  • discount_amount_usd (Field4) — float
  • growth_rate (Field5) — float
  • product_id (Field2) — varchar(100)

user (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar(50)
  • password (Field2) — varchar(50)
  • company_name (Field3) — varchar(100)
  • company_registration_number (Field4) — varchar(50)
  • manager_name (Field5) — varchar(50)
  • manager_department_name (Field6) — varchar(50)
  • manager_phone_number (Field7) — varchar(50)
  • project_name (Field8) — varchar(50)
  • tax_bill_manager_name (Field9) — varchar(50)
  • tax_bill_manager_email (Field10) — varchar(50)
  • tax_bill_manager_phone_number (Field11) — varchar(50)
  • service_use_agreement (Field12) — boolean
  • personal_info_use (Field13) — boolean
  • payment_service_use (Field14) — boolean
  • payment_personal_info_use (Field15) — boolean
  • regular_payment_use (Field16) — boolean

user_auto_payment (Untitled10)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_payment_method_id (Key2) — bigint — Foreign key → user_payment_method.id — NOT NULL
  • user_id (Key22) — bigint — Foreign key → user_payment_method.user_id — NOT NULL
  • exchange_rate_per_month_id (Key3) — bigint — Foreign key → user_payment_method.exchange_rate_per_month_id — NOT NULL
  • applied_date (Key222) — date — Foreign key → user_payment_method.applied_date — NOT NULL
  • product_name (Field2) — varchar(50)
  • duration (Field3) — integer

user_payment_history (Untitled8)

  • id (Key1) — bigint — Primary key
  • user_payment_method_id (Key2) — bigint — Foreign key → user_payment_method.id — NOT NULL
  • user_id (Key22) — bigint — Foreign key → user_payment_method.user_id — NOT NULL
  • exchange_rate_per_month_id (Key3) — bigint — Foreign key → user_payment_method.exchange_rate_per_month_id — NOT NULL
  • applied_date (Key222) — date — Foreign key → user_payment_method.applied_date — NOT NULL
  • invoice_date (Field2) — date
  • payment_status (Field3) — varchar(50)
  • payment_date (Field4) — date
  • nvoice_amount (Field6) — float
  • applied_exchange (Field7) — float
  • paid_amount_krw (Field8) — float
  • vat_krw (Field9) — float
  • total_payment_amount_krw (Field10) — float
  • invoice_url (Field11) — text

user_payment_method (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • exchange_rate_per_month_id (Key3) — bigint — Foreign key → exchange_rate_per_month.id — NOT NULL
  • applied_date (Key22) — date — Foreign key → exchange_rate_per_month.applied_date — NOT NULL
  • payment_method (Field) — varchar(20)
  • card_number (Field2) — varchar(30)
  • duration_year_month (Field3) — varchar(30)
  • birthdate (Field4) — date
  • is_payment_card (Field5) — boolean

voucher (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • name (Field) — varchar(100)

voucher_use_history_table (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • voucher_id (Key2) — bigint — Foreign key → voucher.id — NOT NULL
  • user_id (Key22) — bigint — Foreign key → voucher.user_id — NOT NULL
  • user_amount (Field) — float
  • date (Field2) — date
  • vourcher_type (Field3) — varchar(50)