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