sqlstudy
Tables (5)
Account (Untitled2)
- account_number (Key) — string — Primary key — NOT NULL
- money (Field) — int
- createdat (Field2) — date
Consulting (Untitled5)
- consulting_id (Key2) — int — Primary key — NOT NULL
- Id (Key) — int — Foreign key → customer.Id — NOT NULL
- consulter_id (Field2) — int
- consult_type (Field3) — enum
- consult_date (Field4) — date
- consult_content (Field5) — string
Transaction (Untitled3)
- transy_id (Key) — int — Primary key — NOT NULL
- account_number (Key2) — string — Foreign key → Account.account_number — NOT NULL
- trans_date (Field) — int
- price (Field2) — float
- trans_type (Field3) — enum
- Field4
customer (Untitled)
- Id (Key) — int — Primary key — NOT NULL
- name (Field) — string
- phoneNumber (Field2) — string
- email (Field3) — string
- adress (Field4) — string
product (Untitled4)
- product_id (Key) — int — Primary key — NOT NULL
- account_number (Key2) — string — Foreign key → Account.account_number — NOT NULL
- product_name (Field) — string
- product_type (Field2) — enum
- minimum price (Field3) — float
- interrest_id (Field4) — float