The tables are stored in a mysql database.
+----------------------------+ | Tables_in_ca_scc_contracts | +----------------------------+ | budget_unit_alts | | budget_unit_headings | | budget_unit_joins | | budget_unit_replaces | | budget_units | | contracts | | months | | source_errors | | source_lines | | sources | | supporting_doc_requests | | supporting_docs | | vendor_infos | | vendors | +----------------------------+
CREATE TABLE `budget_unit_alts` (
`pk` int NOT NULL,
`budget_unit_pk` int DEFAULT NULL,
`alt_budget_unit` varchar(127) DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE TABLE `budget_unit_headings` (
`pk` int NOT NULL,
`name` varchar(127) DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
CREATE TABLE `budget_unit_joins` (
`unit_pk` int NOT NULL,
`contract_pk` int NOT NULL,
PRIMARY KEY (`unit_pk`,`contract_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE TABLE `budget_unit_replaces` (
`pk` int NOT NULL,
`bad_name` varchar(127) DEFAULT NULL,
`bad_num` int DEFAULT NULL,
`good_name` varchar(127) DEFAULT NULL,
`good_num` int DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
CREATE TABLE `budget_units` (
`pk` int NOT NULL,
`unit_name` varchar(127) DEFAULT NULL,
`unit_num` int DEFAULT NULL,
`name_in_budget` varchar(127) DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE TABLE `contracts` (
`pk` int NOT NULL,
`owner_name` varchar(63) DEFAULT NULL,
`ariba_id` varchar(31) DEFAULT NULL,
`sap_id` varchar(31) DEFAULT NULL,
`contract_id` varchar(31) DEFAULT NULL,
`contract_type` char(2) DEFAULT NULL,
`vendor_name` varchar(127) DEFAULT NULL,
`vendor_pk` int DEFAULT NULL,
`effective_date` char(10) DEFAULT NULL,
`expir_date` char(10) DEFAULT NULL,
`contract_value` bigint DEFAULT NULL,
`commodity_desc` varchar(1027) DEFAULT NULL,
`authorized_budget_units` varchar(1027) DEFAULT NULL,
`month_pk` int DEFAULT NULL,
`source_pk` int DEFAULT NULL,
`line_num` int DEFAULT NULL,
PRIMARY KEY (`pk`),
KEY `month_pk` (`month_pk`),
KEY `vendor_name` (`vendor_name`),
KEY `vendor_pk` (`vendor_pk`),
KEY `contract_value` (`contract_value`),
KEY `ariba_id` (`ariba_id`,`sap_id`,`contract_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE TABLE `months` (
`pk` int NOT NULL,
`month` char(7) DEFAULT NULL,
`approved` bigint DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE TABLE `source_errors` (
`pk` int NOT NULL,
`source_pk` int DEFAULT NULL,
`contract_pk` int DEFAULT NULL,
`line_num` int DEFAULT NULL,
`line` varchar(1024) DEFAULT NULL,
`is_fixed` tinyint DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
*************************** 1. row ***************************
Table: source_lines
Create Table: CREATE TABLE `source_lines` (
`pk` int NOT NULL,
`source_pk` int DEFAULT NULL,
`line_num` int DEFAULT NULL,
`line` varchar(10230) DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE TABLE `sources` (
`pk` int NOT NULL,
`source_url` varchar(511) DEFAULT NULL,
`month_pk` int DEFAULT NULL,
`content` mediumblob,
PRIMARY KEY (`pk`),
KEY `month_pk` (`month_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE TABLE `supporting_doc_requests` (
`pk` int NOT NULL,
`ariba_id` varchar(31) DEFAULT NULL,
`contract_id` varchar(31) DEFAULT NULL,
`sap_id` varchar(31) DEFAULT NULL,
`vendor_pk` int DEFAULT NULL,
`request_entity` varchar(63) DEFAULT NULL,
`requested` char(10) DEFAULT NULL,
`received` char(10) DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE TABLE `supporting_docs` (
`pk` int NOT NULL,
`vendor_pk` int DEFAULT NULL,
`contract_id` varchar(31) DEFAULT NULL,
`sap_id` varchar(31) DEFAULT NULL,
`ariba_id` varchar(31) DEFAULT NULL,
`url` varchar(1023) DEFAULT NULL,
`request_pk` int DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE TABLE `vendor_infos` (
`pk` int NOT NULL,
`vendor_pk` int DEFAULT NULL,
`key_name` varchar(63) DEFAULT NULL,
`value_str` varchar(1023) DEFAULT NULL,
`created` bigint DEFAULT NULL,
`updated` int DEFAULT NULL,
PRIMARY KEY (`pk`),
KEY `vendor_pk` (`vendor_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
CREATE TABLE `vendors` (
`pk` int NOT NULL,
`name` varchar(127) DEFAULT NULL,
PRIMARY KEY (`pk`),
UNIQUE KEY `name` (`name`),
KEY `name_2` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3