📂 Complete Database Schema Output

TABLE: announcements

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
title	varchar(200)	NO		NULL
content	text	NO		NULL
target_contractor_code	varchar(50)	YES		NULL
created_by	varchar(100)	NO		NULL
created_at	timestamp	YES		current_timestamp()

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
contract_number	varchar(50)	NO	MUL	NULL
file_description	enum('FullCopy','Amendment','FRA','Letters')	NO		NULL
file_path	varchar(255)	NO		NULL
uploaded_at	timestamp	YES		current_timestamp()

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
contract_number	varchar(50)	NO		NULL
counseling_date	date	NO		NULL
subject	varchar(200)	NO		NULL
details	text	NO		NULL
action_item	text	NO		NULL
target_date	date	NO		NULL
status	enum('OPEN','CLOSED')	YES		OPEN
created_at	timestamp	YES		current_timestamp()

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
contract_number	varchar(50)	NO	UNI	NULL
contract_name	varchar(200)	NO		NULL
contractor_name	varchar(150)	NO		NULL
contractor_code	varchar(50)	NO	MUL	NULL
start_date	date	NO		NULL
end_date	date	NO		NULL
ael_limit	decimal(15,2)	NO		0.00
contract_type	enum('LFC','SFC')	NO		LFC
dept_id	int(11)	YES	MUL	NULL
status	enum('ACTIVE','INACTIVE')	NO		ACTIVE
created_at	timestamp	YES		current_timestamp()

Field	Type	Null	Key	Default
counseling_number	varchar(50)	NO	PRI	NULL
counseling_date	date	NO		NULL
contract_number	varchar(50)	NO	MUL	NULL
category	enum('MAJOR','MINOR')	NO		MINOR
requester	varchar(100)	NO		NULL
requesting_dept_id	int(11)	NO	MUL	NULL
reason	text	NO		NULL
created_at	timestamp	YES		current_timestamp()

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
counseling_number	varchar(50)	NO	MUL	NULL
contract_number	varchar(50)	NO		NULL
action_description	text	NO		NULL
assigned_user	varchar(100)	NO		NULL
status	enum('started','completed','canceled','on hold','in progress','delayed')	YES		started
etc_date	date	NO		NULL
updated_at	timestamp	YES		current_timestamp()	on update current_timestamp()

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
req_code	varchar(50)	NO	UNI	NULL
req_name	varchar(150)	NO		NULL
req_type	varchar(50)	NO		NULL
contract_type	enum('LFC','SFC')	NO		LFC
reviewer_username	varchar(100)	NO		NULL
template_attachment	varchar(255)	YES		NULL
created_at	timestamp	YES		current_timestamp()

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
obligation_id	varchar(50)	NO	UNI	NULL
req_code	varchar(50)	NO		NULL
req_name	varchar(150)	NO		NULL
req_type	varchar(50)	NO		NULL
status	enum('PENDING','UPLOADED')	YES		PENDING
attachment_url	varchar(255)	YES		NULL
upload_date	datetime	YES		NULL
expiry_date	date	YES		NULL
updated_at	timestamp	YES		current_timestamp()	on update current_timestamp()

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
so_number	varchar(50)	NO	UNI	NULL
contract_number	varchar(50)	NO		NULL
service_description	text	YES		NULL
amount	decimal(15,2)	NO		NULL
charge_account	varchar(100)	YES		NULL
type_of_service	enum('workunit','timeunit')	NO		workunit
scope_type	enum('normal','shutdown')	NO		normal
requesting_dept_id	int(11)	YES		NULL
requester_username	varchar(100)	YES		NULL
signed_by_sh	varchar(100)	YES		NULL
signed_by_mngr	varchar(100)	YES		NULL
signed_by_gm	varchar(100)	YES		NULL
sign_date	date	YES		NULL
contractor_response	enum('Pending','Accepted','Rejected')	YES		Pending
contractor_response_date	date	YES		NULL
contractor_remark	text	YES		NULL
start_date	date	YES		NULL
expiry_date	date	YES		NULL
so_status	enum('New','CS','CANCELED')	YES		New
description	text	YES		NULL
status	enum('APPROVED','PENDING')	YES		PENDING
created_at	timestamp	YES		current_timestamp()

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
entity_type	enum('CONTRACT','COUNSELING','OBLIGATION','SERVICE_ORDER')	NO	MUL	NULL
entity_id	varchar(100)	NO		NULL
file_name	varchar(255)	NO		NULL
file_path	varchar(255)	NO		NULL
uploaded_by	varchar(100)	NO		NULL
uploaded_at	timestamp	YES		current_timestamp()

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
dept_name	varchar(100)	NO		NULL
manager_username	varchar(100)	NO		NULL
focal_point_username	varchar(100)	NO		NULL

Field	Type	Null	Key	Default	Extra
form_name	varchar(100)	NO	PRI	NULL
form_label	varchar(100)	NO		NULL

Field	Type	Null	Default
UserId	tinyint(4)	NO	NULL
Username	varchar(100)	NO	NULL
FullName	varchar(150)	YES	NULL
password	varchar(100)	NO	NULL
email	varchar(100)	NO	NULL
UserType	enum('CONTRACTOR','CCS','ADMIN')	NO	CONTRACTOR
ContractorCode	varchar(50)	YES	NULL
ContractNumber	varchar(50)	YES	NULL
ContractType	enum('LFC','SFC')	YES	NULL

Field	Type	Null	Key	Default	Extra
target_value	varchar(100)	NO	PRI	NULL
target_type	enum('ROLE','CODE','USER')	NO	PRI	NULL

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
document_id	varchar(50)	NO		NULL
action_by	varchar(100)	NO		NULL
action_type	varchar(20)	NO		NULL
user_comment	text	YES		NULL
action_date	timestamp	YES		current_timestamp()

Field	Type	Null	Key	Default	Extra
document_id	varchar(100)	NO	PRI	NULL
form_name	varchar(100)	NO		NULL
current_step_id	int(11)	NO		NULL
assigned_target	varchar(50)	NO		NULL
assignment_type	varchar(20)	NO		NULL
status	varchar(50)	NO		NULL
creator_id	varchar(50)	NO		NULL
current_action	varchar(100)	YES		P
workflow_type	varchar(50)	YES		STANDARD
payload_json	text	NO		NULL
attachment_url	varchar(255)	YES		NULL
updated_at	timestamp	YES		current_timestamp()	on update current_timestamp()

Field	Type	Null	Key	Default	Extra
setting_key	varchar(100)	NO	PRI	NULL
setting_value	varchar(255)	NO		NULL

Field	Type	Null	Key	Default
form_name	varchar(100)	NO	PRI	NULL
form_id_col	varchar(100)	NO		NULL
steps_json	text	NO		NULL

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
matrix_target_type	enum('ROLE','CODE')	NO		NULL
matrix_target_value	varchar(100)	NO		NULL