pleytedts.online / 127.0.0.1 / ormoc_db

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

v		ormoc_db cenro_action_incoming
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db cenro_action_outgoing
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
section_outgoing_receiver : varchar(55)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

section_outgoing_receiver : varchar(55)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db cenro_recv_incoming
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
section_outgoing_receiver : varchar(55)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

section_outgoing_receiver : varchar(55)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db cenro_recv_outgoing
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
section_outgoing_receiver : varchar(55)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

section_outgoing_receiver : varchar(55)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db document_table
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
section_outgoing_receiver : varchar(55)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
cenro_outgoing_receiver : varchar(55)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
records_outgoing_receiver : varchar(55)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

section_outgoing_receiver : varchar(55)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

cenro_outgoing_receiver : varchar(55)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

records_outgoing_receiver : varchar(55)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db focal_action_incoming
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db focal_action_outgoing
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db focal_recv_incoming
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db focal_recv_outgoing
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db records_action_incoming
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
section_outgoing_receiver : varchar(55)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

section_outgoing_receiver : varchar(55)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db records_action_outgoing
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
section_outgoing_receiver : varchar(55)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
cenro_outgoing_receiver : varchar(55)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

section_outgoing_receiver : varchar(55)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

cenro_outgoing_receiver : varchar(55)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db records_recv_incoming
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db records_recv_outgoing
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
section_outgoing_receiver : varchar(55)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
cenro_outgoing_receiver : varchar(55)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

section_outgoing_receiver : varchar(55)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

cenro_outgoing_receiver : varchar(55)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db section_action_incoming
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db section_action_outgoing
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db section_recv_incoming
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db section_recv_outgoing
id : int(11)
records_transactionno : varchar(255)
records_processor : varchar(25)
records_section : varchar(55)
records_workgroup : varchar(25)
records_sender : varchar(25)
records_address : varchar(100)
records_daterecv : varchar(55)
records_subject : varchar(255)
records_documentsource : varchar(25)
records_doctype : varchar(25)
records_documentstatus : varchar(55)
records_officeorigin : varchar(25)
records_dateprocessed : text
records_time : text
records_receiver : varchar(55)
cenro_recvdate : varchar(55)
cenro_recvtime : varchar(55)
cenro_processor : varchar(55)
cenro_workgroup : varchar(55)
cenro_section : varchar(55)
cenro_priority : varchar(55)
cenro_action : varchar(55)
cenro_action_others : varchar(255)
cenro_receiver : varchar(55)
cenro_dateprocessed : varchar(55)
cenro_time : varchar(55)
section_recvdate : varchar(55)
section_recvtime : varchar(55)
section_processor : varchar(55)
section_workgroup : varchar(55)
section_section : varchar(55)
section_priority : varchar(55)
section_action : varchar(55)
section_action_others : varchar(255)
section_receiver : varchar(55)
section_dateprocessed : varchar(55)
section_time : varchar(55)
focal_recvdate : varchar(25)
focal_recvtime : varchar(25)
focal_processor : varchar(55)
focal_workgroup : varchar(55)
focal_section : varchar(55)
focal_action : varchar(255)
focal_dateprocessed : varchar(25)
focal_time : varchar(25)
focal_receiver : varchar(55)
section_outgoing_recvdate : varchar(25)
section_outgoing_recvtime : varchar(25)
section_outgoing_processor : varchar(25)
section_outgoing_workgroup : varchar(55)
section_outgoing_section : varchar(55)
section_outgoing_action : varchar(255)
section_outgoing_dateprocessed : varchar(25)
section_outgoing_time : varchar(25)
cenro_outgoing_recvdate : varchar(25)
cenro_outgoing_recvtime : varchar(25)
cenro_outgoing_processor : varchar(55)
cenro_outgoing_workgroup : varchar(55)
cenro_outgoing_section : varchar(55)
cenro_outgoing_action : varchar(255)
cenro_outgoing_dateprocessed : varchar(25)
cenro_outgoing_time : varchar(25)
records_outgoing_recvdate : varchar(25)
records_outgoing_recvtime : varchar(25)
records_outgoing_processor : varchar(55)
records_outgoing_workgroup : varchar(55)
records_outgoing_section : varchar(55)
records_outgoing_action : varchar(255)
records_outgoing_dateprocessed : varchar(25)
records_outgoing_time : varchar(25)
section_reroute_recvdate : varchar(25)
section_reroute_recvtime : varchar(25)
section_reroute_processor : varchar(55)
section_reroute_workgroup : varchar(55)
section_reroute_section : varchar(55)
section_reroute_remarks : varchar(255)
section_reroute_dateprocessed : varchar(25)
section_reroute_time : varchar(25)
section_reroute_receiver : varchar(55)
focal_reroute_recvdate : varchar(25)
focal_reroute_recvtime : varchar(25)
focal_reroute_processor : varchar(55)
focal_reroute_workgroup : varchar(55)
focal_reroute_section : varchar(55)
focal_reroute_remarks : varchar(255)
focal_reroute_dateprocessed : varchar(25)
focal_reroute_time : varchar(25)
focal_reroute_receiver : varchar(55)

id : int(11)

records_transactionno : varchar(255)

records_processor : varchar(25)

records_section : varchar(55)

records_workgroup : varchar(25)

records_sender : varchar(25)

records_address : varchar(100)

records_daterecv : varchar(55)

records_subject : varchar(255)

records_documentsource : varchar(25)

records_doctype : varchar(25)

records_documentstatus : varchar(55)

records_officeorigin : varchar(25)

records_dateprocessed : text

records_time : text

records_receiver : varchar(55)

cenro_recvdate : varchar(55)

cenro_recvtime : varchar(55)

cenro_processor : varchar(55)

cenro_workgroup : varchar(55)

cenro_section : varchar(55)

cenro_priority : varchar(55)

cenro_action : varchar(55)

cenro_action_others : varchar(255)

cenro_receiver : varchar(55)

cenro_dateprocessed : varchar(55)

cenro_time : varchar(55)

section_recvdate : varchar(55)

section_recvtime : varchar(55)

section_processor : varchar(55)

section_workgroup : varchar(55)

section_section : varchar(55)

section_priority : varchar(55)

section_action : varchar(55)

section_action_others : varchar(255)

section_receiver : varchar(55)

section_dateprocessed : varchar(55)

section_time : varchar(55)

focal_recvdate : varchar(25)

focal_recvtime : varchar(25)

focal_processor : varchar(55)

focal_workgroup : varchar(55)

focal_section : varchar(55)

focal_action : varchar(255)

focal_dateprocessed : varchar(25)

focal_time : varchar(25)

focal_receiver : varchar(55)

section_outgoing_recvdate : varchar(25)

section_outgoing_recvtime : varchar(25)

section_outgoing_processor : varchar(25)

section_outgoing_workgroup : varchar(55)

section_outgoing_section : varchar(55)

section_outgoing_action : varchar(255)

section_outgoing_dateprocessed : varchar(25)

section_outgoing_time : varchar(25)

cenro_outgoing_recvdate : varchar(25)

cenro_outgoing_recvtime : varchar(25)

cenro_outgoing_processor : varchar(55)

cenro_outgoing_workgroup : varchar(55)

cenro_outgoing_section : varchar(55)

cenro_outgoing_action : varchar(255)

cenro_outgoing_dateprocessed : varchar(25)

cenro_outgoing_time : varchar(25)

records_outgoing_recvdate : varchar(25)

records_outgoing_recvtime : varchar(25)

records_outgoing_processor : varchar(55)

records_outgoing_workgroup : varchar(55)

records_outgoing_section : varchar(55)

records_outgoing_action : varchar(255)

records_outgoing_dateprocessed : varchar(25)

records_outgoing_time : varchar(25)

section_reroute_recvdate : varchar(25)

section_reroute_recvtime : varchar(25)

section_reroute_processor : varchar(55)

section_reroute_workgroup : varchar(55)

section_reroute_section : varchar(55)

section_reroute_remarks : varchar(255)

section_reroute_dateprocessed : varchar(25)

section_reroute_time : varchar(25)

section_reroute_receiver : varchar(55)

focal_reroute_recvdate : varchar(25)

focal_reroute_recvtime : varchar(25)

focal_reroute_processor : varchar(55)

focal_reroute_workgroup : varchar(55)

focal_reroute_section : varchar(55)

focal_reroute_remarks : varchar(255)

focal_reroute_dateprocessed : varchar(25)

focal_reroute_time : varchar(25)

focal_reroute_receiver : varchar(55)

v		ormoc_db user_table
user_ID : int(255)
ormoc_username : varchar(55)
ormoc_password : varchar(55)
ormoc_name : varchar(55)
ormoc_section : varchar(55)
ormoc_workgroup : varchar(55)
ormoc_usertype : varchar(55)

user_ID : int(255)

ormoc_username : varchar(55)

ormoc_password : varchar(55)

ormoc_name : varchar(55)

ormoc_section : varchar(55)

ormoc_workgroup : varchar(55)

ormoc_usertype : varchar(55)

Create relationship

FOREIGN KEY

on delete

on update

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -