Database Structure


NewsItems

Field Name Data Type Notes Default Required
story_id smallint(4) primary key, unsigned, not null,
auto_increment		   Y
story_date date      
story_status tinyint(1)   1=draft or 2=publish Y
headline tinytext      
byline tinytext      
story_text_1 text      
story_text_2 text      
story_text_3 text      
story_text_4 text      
story_text_5 text      
image1 tinytext      
image2 tinytext      
image3 tinytext      
createdon_date date   current date  
createdby_user smallint(3) foreign key, unsigned    


TeamUsers

Field Name Data Type Notes Default Required
user_id smallint(3) primary key, unsigned, not null, auto_increment   Y
user_status tinyint(1)  

0=inactive user
1= general user
2=admin user
3=master account

Y
first_name varchar(15)     Y
last_name varchar(15)      
login_id varchar(10)     Y
passwd tinytext     Y
department tinytext      
email varchar(30)      
home_phone varchar(14)      
mobile_phone varchar(14)      
office_phone varchar(14)      
office_phone_ext varchar(4)      


Docs

Field Name Data Type Notes Default Required
doc_id smallint(4) primary key, unsigned, not null, auto_increment   Y
doc_type_id smallint(2) foreign key, unsigned   Y
subsystem_id smallint(2) foreign key, unsigned   Y
comments text      
file_name tinytext     Y
uploadedon_date date   current date Y
uploadedby_user smallint(3) foreign key, unsigned   Y


DocTypes

Field Name Data Type Notes Default Required
doc_type_id smallint(2) primary key,
unsigned, not null, auto_increment 		  Y
doc_type tinytext     Y
doc_type_status tinyint(1)  

0=inactive
1=active

 Y


Subsystems

Field Name Data Type Notes Default Required
subsystem_id smallint(2) primary key,
unsigned, not null, auto_increment 		  Y
subsystem_name tinytext     Y
subsystem_status tinyint(1)  

0=inactive
1=active

 Y

 

ActionItems

Field Name Data Type Notes Default Required
action_item_id smallint(4) primary key, unsigned, not null, auto_increment   Y
description text     Y
due_date date      
assignee smallint(3) foreign key, unsigned    
item_status tinyint(1)  

1=current
2=complete

  
ref_number tinytext      
createdon_date date   current date Y
createdby_user smallint(3) foreign key, unsigned   Y


Telemetry

Field Name Data Type Notes Default Required
caller_id mediumint(8) primary key, unsigned, not null, auto_increment   Y
call_sign varchar(6)      
uploads_size tinytext      


Blog: News & Events

Depending on the blogging software we choose to install, there will be a set of tables to create for it. They will be listed here as we select the software.