stockrelationdb

Tables (5)

Sector_Master (SECTOR_MASTER)

  • SectorCode (SECTOR_CODE) — VARCHAR(6) — Primary key — NOT NULL
  • SectorName (SECTOR_NAME) — VARCHAR(100)

Sector_Sector (SECTOR_SECTOR)

  • id (ID) — int — Primary key — NOT NULL
  • SectorCode (SECTOR_CODE) — VARCHAR(6) — Foreign key → Sector_Master.SectorCode — NOT NULL
  • SectorCode (SECTOR_CODE2) — VARCHAR(6) — Foreign key → Sector_Master.SectorCode — NOT NULL

Stock_Master (STOCK_MASTER)

  • Stock Code (STOCK_CODE) — VARCHAR(6) — Primary key — NOT NULL
  • Stock Name (STOCK_NAME) — VARCHAR(100)

Stock_Sector (STOCK_SECTOR)

  • id (ID) — int — Primary key — NOT NULL
  • Stock Code (STOCK_CODE) — VARCHAR(6) — Foreign key → Stock_Master.Stock Code — NOT NULL
  • SectorCode (SECTOR_CODE) — VARCHAR(6) — Foreign key → Sector_Master.SectorCode — NOT NULL

Stock_Stock (STOCK_STOCK)

  • id (ID) — int — Primary key — NOT NULL
  • Stock Code (STOCK_CODE) — VARCHAR(6) — Foreign key → Stock_Master.Stock Code — NOT NULL
  • Stock Code (STOCK_CODE2) — VARCHAR(6) — Foreign key → Stock_Master.Stock Code — NOT NULL