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