test
Tables (17)
client
- is_deleted — bit — NOT NULL
- client_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- phone — varchar(20) — NOT NULL
- name — varchar(50) — NOT NULL
- auth_code — varchar(60) — NOT NULL
consent_account
- is_deleted — bit — NOT NULL
- created_at — datetime(6) — NOT NULL
- member_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- number — varchar(20) — NOT NULL
- bank — varchar(50) — NOT NULL
- owner — varchar(50) — NOT NULL
- sign_url — varchar(512) — NOT NULL
contract
- contract_cycle — int — NOT NULL
- is_deleted — bit — NOT NULL
- is_easy_consent — bit — NOT NULL
- is_subscription — bit — NOT NULL
- item_amount — int — NOT NULL
- payment_due_cycle — int — NOT NULL
- contract_id — bigint
- contract_status_id — bigint — NOT NULL
- created_at — datetime(6) — NOT NULL
- invoice_type_id — bigint — NOT NULL
- item_id — bigint — NOT NULL
- item_price — bigint — NOT NULL
- member_id — bigint — NOT NULL
- payment_type_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
contract_status
- is_deleted — bit — NOT NULL
- contract_status_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- name — varchar(50) — NOT NULL
flyway_schema_history
- installed_rank — int — NOT NULL
- version — varchar(50)
- description — varchar(200) — NOT NULL
- type — varchar(20) — NOT NULL
- script — varchar(1000) — NOT NULL
- checksum — int
- installed_by — varchar(100) — NOT NULL
- installed_on — timestamp — NOT NULL
- execution_time — int — NOT NULL
- success — tinyint(1) — NOT NULL
invoice
- is_deleted — bit — NOT NULL
- charge_amount — bigint — NOT NULL
- contract_date — datetime(6) — NOT NULL
- contract_id — bigint — NOT NULL
- created_at — datetime(6) — NOT NULL
- due_date — datetime(6) — NOT NULL
- invoice_id — bigint
- invoice_type_id — bigint — NOT NULL
- payment_status_id — bigint — NOT NULL
- payment_type_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
invoice_statistics
- id — bigint
- reference_date — timestamp — NOT NULL
- total_invoiced — bigint — NOT NULL
- total_collected — bigint — NOT NULL
- outstanding — bigint — NOT NULL
- type_id — bigint — NOT NULL
- year — int — NOT NULL
- month — int
- week — int
- client_id — bigint — NOT NULL
- is_deleted — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
invoice_statistics_type
- id — bigint
- type_name — varchar(50) — NOT NULL
- is_deleted — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
invoice_type
- is_deleted — bit — NOT NULL
- created_at — datetime(6) — NOT NULL
- invoice_type_id — bigint
- updated_at — datetime(6) — NOT NULL
- name — varchar(50) — NOT NULL
item
- is_basic — bit — NOT NULL
- is_deleted — bit — NOT NULL
- client_id — bigint — NOT NULL
- created_at — datetime(6) — NOT NULL
- item_id — bigint
- price — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- name — varchar(50) — NOT NULL
- image_url — varchar(512) — NOT NULL
- description — varchar(255) — NOT NULL
member
- is_deleted — bit — NOT NULL
- client_id — bigint — NOT NULL
- created_at — datetime(6) — NOT NULL
- member_id — bigint
- updated_at — datetime(6) — NOT NULL
- phone — varchar(20) — NOT NULL
- name — varchar(50) — NOT NULL
- description — varchar(255)
- email — varchar(255) — NOT NULL
payment
- is_deleted — bit — NOT NULL
- created_at — datetime(6) — NOT NULL
- invoice_id — bigint — NOT NULL
- pay_amount — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- payment_method — varchar(50) — NOT NULL
payment_account
- is_deleted — bit — NOT NULL
- created_at — datetime(6) — NOT NULL
- invoice_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- number — varchar(20) — NOT NULL
- bank — varchar(50) — NOT NULL
- owner — varchar(50) — NOT NULL
payment_card
- is_deleted — bit — NOT NULL
- created_at — datetime(6) — NOT NULL
- invoice_id — bigint — NOT NULL
- updated_at — datetime(6) — NOT NULL
- number — varchar(20) — NOT NULL
- company — varchar(50) — NOT NULL
- owner — varchar(50) — NOT NULL
payment_status
- is_deleted — bit — NOT NULL
- created_at — datetime(6) — NOT NULL
- payment_status_id — bigint
- updated_at — datetime(6) — NOT NULL
- name — varchar(50) — NOT NULL
payment_type
- is_deleted — bit — NOT NULL
- created_at — datetime(6) — NOT NULL
- payment_type_id — bigint
- updated_at — datetime(6) — NOT NULL
- name — varchar(50) — NOT NULL
- is_basic — bit — NOT NULL
user
- is_deleted — bit — NOT NULL
- client_id — bigint — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- user_id — bigint
- phone — varchar(20) — NOT NULL
- name — varchar(50) — NOT NULL
- password — varchar(60) — NOT NULL
- email — varchar(255) — NOT NULL