|
CompanyCode
|
double(20,2)
|
|
|
|
|
ParentCompanyCode
|
double(20,2)
|
|
|
|
|
CompanyName
|
varchar(75)
|
utf8mb4_general_ci
|
|
|
|
ShortCompanyName
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
TickerName
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
PersonDescription
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
PersonName
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
ExecutiveDescription
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
ExecutiveName
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
ExchangeCode
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
ExchangeName
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
ExchangeGroup
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
Sourcetype
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
IncorporationDate
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
FirstPublicIssueDate
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
Auditeddate
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
FaceValue
|
double(20,2)
|
|
|
|
|
Marketlot
|
int(10)
|
|
|
|
|
IndustryCode
|
int(10)
|
|
|
|
|
IndustryName
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
BusinessGroupCode
|
int(10)
|
|
|
|
|
BusinessGroupName
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
MajorSector
|
int(10)
|
|
|
|
|
LatestFinYear
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
ForemostFinYear
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
LatestHalfYear
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
ForemostHalfYear
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
LatestQtrYear
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
ForemostQtrYear
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
ModifiedDate
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
