|
admin_proj_detail_id
|
int(11)
|
|
|
|
|
oa_no
|
varchar(255)
|
|
|
|
|
proj_no
|
varchar(45)
|
|
|
|
|
org_id
|
int(11)
|
|
|
|
|
proj_name
|
varchar(200)
|
|
|
|
|
quantity
|
decimal(10,3)
|
|
|
|
|
proj_trgt_manf_date
|
date
|
|
|
1970-01-01
|
|
proj_trgt_date
|
date
|
|
|
1970-01-01
|
|
proj_manager
|
varchar(60)
|
|
|
|
|
proj_coord
|
varchar(255)
|
|
|
|
|
purchase_coord
|
varchar(100)
|
|
|
|
|
estmtd_no_parts
|
int(11)
|
|
|
|
|
proj_start_date
|
date
|
|
|
|
|
proj_end_date
|
date
|
|
|
|
|
proj_budget
|
decimal(10,2)
|
|
|
|
|
status_flag
|
varchar(15)
|
|
|
W
|
|
design_trgt_date
|
date
|
|
|
|
|
hsn_code
|
varchar(8)
|
|
|
|
|
status_interval
|
int(11)
|
|
|
7
|
