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)