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