|
fin_code
|
int(10)
|
|
|
|
|
scrip_code
|
int(10)
|
|
|
|
|
scrip_name
|
varchar(35)
|
utf8mb4_general_ci
|
|
|
|
scrip_group
|
varchar(3)
|
utf8mb4_general_ci
|
|
|
|
co_name
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
ind_code
|
int(10)
|
|
|
|
|
industry
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
hse_code
|
int(10)
|
|
|
|
|
house
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
symbol
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
series
|
varchar(2)
|
utf8mb4_general_ci
|
|
|
|
isin
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
co_short_name
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
res_format
|
varchar(5)
|
utf8mb4_general_ci
|
|
|
|
fin_format
|
varchar(5)
|
utf8mb4_general_ci
|
|
|
|
chairman
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
mdir
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
co_sec
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
inc_month
|
varchar(15)
|
utf8mb4_general_ci
|
|
|
|
inc_year
|
varchar(4)
|
utf8mb4_general_ci
|
|
|
|
fv
|
float(10,2)
|
|
|
|
|
status
|
varchar(15)
|
utf8mb4_general_ci
|
|
|
|
sub_listing
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
bse_scrip_id
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
sec_token
|
int(10)
|
|
|
|
|
cin
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
bse_sub_list
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
nse_sub_list
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
flag
|
varchar(1)
|
utf8mb4_general_ci
|
|
|
