ASDF

Tables (12)

DividendHistory

  • id — BIGINT
  • stock_id — BIGINT
  • account_id — BIGINT
  • dividend_amount — DECIMAL(15, 2)
  • payment_date — DATETIME

HeldStocks

  • id — BIGINT
  • account_id — BIGINT
  • stock_id — BIGINT
  • quantity — INT
  • purchase_date — DATETIME

Industry

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL

Market

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • country — VARCHAR(50)

Order

  • id — BIGINT
  • account_id — BIGINT
  • stock_id — BIGINT
  • order_type_id — BIGINT
  • quantity — INT
  • price — DECIMAL(15, 2)
  • order_date — DATETIME
  • status — VARCHAR(50)

SalesHistory

  • id — BIGINT
  • account_id — BIGINT
  • stock_id — BIGINT
  • sale_price — DECIMAL(15, 2)
  • quantity — INT
  • sale_date — DATETIME

Sector

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL

Stock

  • id — BIGINT
  • ticker — VARCHAR(10) — NOT NULL
  • company_name — VARCHAR(100)
  • market — VARCHAR(50)
  • sector — VARCHAR(50)
  • industry — VARCHAR(50)

StockAccount

  • id — BIGINT
  • account_number — VARCHAR(50) — NOT NULL
  • owner_name — VARCHAR(100)
  • balance — DECIMAL(15, 2)
  • creation_date — DATETIME

StockHistory

  • id — BIGINT
  • stock_id — BIGINT
  • price — DECIMAL(15, 2)
  • time — DATETIME
  • volume — INT

TransactionType

  • id — BIGINT
  • type_name — VARCHAR(50) — NOT NULL

User

  • id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100)
  • full_name — VARCHAR(100)
  • registration_date — DATETIME