minisoda

mariadb-db-schema

Tables (7)

Account (account)

  • Key (account_id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → Member.Key — NOT NULL
  • Key (openapi_id) — int — Foreign key → Openapi.Key — NOT NULL

Bankcode (bankcode)

  • Key (bankcode_id) — int — Primary key — NOT NULL
  • Field (code) — varchar(20)

Member (member)

  • Key (member_id) — int — Primary key — NOT NULL
  • Field (first_name) — varchar(20)
  • Field (last_name) — varchar(20)
  • Field (country) — varchar(20)
  • Field (province) — varchar(20)
  • Field (city) — varchar(20)
  • Field (street) — varchar(20)
  • Field (house_number) — int
  • Field (phone_number) — varchar(11)
  • Field (email) — varchar(200)

Openapi (openapi)

  • Key (openapi_id) — int — Primary key — NOT NULL
  • Key (bankcode_id) — int — Foreign key → Bankcode.Key — NOT NULL
  • Field (account_number) — varchar(50)
  • Field (owner) — varchar(50)
  • Field (balance) — bigint unsigned

Transaction (transaction)

  • Key (transaction_id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → Member.Key — NOT NULL
  • Key (send_account) — int — Foreign key → Openapi.Key — NOT NULL
  • Field (recv_account) — int
  • Field (amount) — bigint unsigned
  • Field (after_balance) — bigint
  • Field (transaction_status) — varchar(10)
  • Field (process_at) — timestamp

Untitled (role)

  • Key (role_id) — int — Primary key — NOT NULL
  • Field (rolename) — varchar(50)

Untitled (member_role)

  • Key (member_role_id) — int — Primary key — NOT NULL
  • Key (member_id) — int — Foreign key → Member.Key — NOT NULL
  • Key (role_id) — int — Foreign key → Untitled.Key — NOT NULL