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