| Reasoning about a data dictionary, using meta-data provided by Sonya McNeal Version 20041124 the primary key of the table some-name1 includes the column some-column the primary key of the table some-name2 includes the column that-column that-name1 is placed alphabetically before that-name2 ---------------------------------------------------------------------------------------------- the table that-name1 and the table that-name2 both have primary keys that include that-column the table some-name1 has a column some-column with type some-type1 some-null/not-null1 the table some-name2 has a column that-column with type some-type2 some-null/not-null2 that-name1 is placed alphabetically before that-name2 -------------------------------------------------------------------------------------- the table that-name1 and the table that-name2 each have a column that-column the table some-name1 has a column some-column with type some-type1 some-null/not-null1 the table some-name2 has a column that-column with type some-type2 some-null/not-null2 that-null/not-null1 is not equal that-null/not-null2 that-name1 is placed alphabetically before that-name2 ----------------------------------------------------------------------------------------------------- the table that-name1 and the table that-name2 each have a column that-column but with different NULLs the primary key of the table this-name includes the column this-column =========================================================================== audit_data tablename audit_data fieldname audit_data keydata audit_data changetime audit_fields fieldalias best_execution loanid best_execution commitmentnumber best_execution poolnumber best_execution packetnumber comments_loan_servicing commentid comments_loan_servicing commentcount comments_vartext vartextid comments_vartext vartextcount commitment_excessservicing commitmentnumber commitment_excessservicing servicerldid commitment_excessservicing servicerid commitment_excessservicing sequencenumber commitment_master commitmentnumber commitment_masterproduct commitmentnumber commitment_masterproduct productid commitment_masterproduct gradealias commitment_masterservicer commitmentnumber commitment_masterservicer servicerldid commitment_masterservicer servicerid commitment_packet commitmentnumber commitment_packet poolnumber commitment_packet packetnumber commitment_packet_psa psaid commitment_pool commitmentnumber commitment_pool poolnumber commitment_pool poolfundedflag the table audit_data has a column this-column with type this-type this-null/not-null ================================================================================== changetime datetime NOT NULL changetype char(1) NOT NULL fieldname varchar(35) NOT NULL fieldvalue varchar(255) NULL keydata varchar(128) NOT NULL tablename varchar(35) NOT NULL userid integer NOT NULL the table this-name has an index this-index that includes column this-col ========================================================================= audit_data ixaudit_data01 tablename audit_data ixaudit_data01 fieldname audit_data ixaudit_data01 changetime the table audit_fields has a column this-column with type this-type this-null/not-null ================================================================================== decimalplaces smallint NULL fieldalias varchar(80) NOT NULL fieldname varchar(35) NULL numericformat varchar(20) NULL tablename varchar(35) NULL the table best_execution has a column this-column with type this-type this-null/not-null ======================================================================================== commitmentnumber varchar(20) NOT NULL grossprofit double precision NULL loanid varchar(20) NOT NULL packetnumber varchar(20) NOT NULL poolnumber varchar(20) NOT NULL the table comments_loan_servicing has a column this-column with type this-type this-null/not-null ================================================================================================= addedby varchar(255) NULL commentcount integer NOT NULL commentid integer NOT NULL dateadded datetime NULL timeadded varchar(20) NULL vartextid integer NULL the table comments_vartext has a column this-column with type this-type this-null/not-null ================================================================================================= vartext varchar(255) NULL vartextcount integer NOT NULL vartextid integer NOT NULL the table commitment_excessservicing has a column this-column with type this-type this-null/not-null ===================================================================================================== commitmentnumber varchar(20) NOT NULL multiplier double precision NULL sequencenumber integer NOT NULL servicerid integer NOT NULL servicerldid integer NOT NULL spread double precision NULL the table commitment_master has a column this-column with type this-type this-null/not-null =========================================================================================== allocated double precision NULL allowmortgageinsurance smallint NULL amount double precision NULL commitmentnumber varchar(20) NOT NULL description varchar(50) NULL expirationdate datetime NULL guaranteefee double precision NULL investorid integer NULL investorldid integer NULL marketsymbolid integer NULL maximumbuyup double precision NULL minimumservicefee double precision NULL negotiationdate datetime NULL threshold double precision NULL the table commitment_masterproduct has a column this-column with type this-type this-null/not-null ================================================================================================= commitmentnumber varchar(20) NOT NULL gradealias varchar(10) NOT NULL productid integer NOT NULL the table commitment_masterservicer has a column this-column with type this-type this-null/not-null ================================================================================================= baseservicefee double precision NULL basesrp double precision NULL commitmentnumber varchar(20) NOT NULL servicerid integer NOT NULL servicerldid integer NOT NULL the table commitment_packet has a column this-column with type this-type this-null/not-null =========================================================================================== allocated double precision NULL amount double precision NULL buydownfactor double precision NULL buyupfactor double precision NULL commitmentnumber varchar(20) NOT NULL conversionratioid varchar(20) NULL couponrate double precision NULL deliverbydate datetime NULL deliverydate datetime NULL deliveryfee double precision NULL description varchar(50) NULL designator varchar(3) NULL displaycode varchar(10) NULL fundeddate datetime NULL mktmarginadj double precision NULL mktrateadj double precision NULL packetdeliveredflag varchar(1) NULL packetfundedflag varchar(1) NULL packetnumber varchar(20) NOT NULL parmargin double precision NULL parrate double precision NULL poolnumber varchar(20) NOT NULL price double precision NULL psaid integer NULL querycode varchar(10) NULL SelectStatus integer NULL servicefee double precision NULL sortcode varchar(10) NULL threshold double precision NULL ttlgrossprofit double precision NULL ttlweightedcoupon double precision NULL ttlweightedmargin double precision NULL usebuyupdown smallint NULL the table commitment_packet_psa has a column this-column with type this-type this-null/not-null =============================================================================================== psadate datetime NULL psaid integer NOT NULL psareference varchar(10) NULL psareferencedescription varchar(50) NULL the table commitment_pool has a column this-column with type this-type this-null/not-null =============================================================================================== accrualratemethod varchar(1) NULL allocated double precision NULL amount double precision NULL assignmentoftrade smallint NULL cappedprice double precision NULL commitmentfee double precision NULL commitmentnumber varchar(20) NOT NULL commitmentperiod smallint NULL contractguarantyfee double precision NULL couponrate double precision NULL deliverycontractnumber varchar(6) NULL deliverydate datetime NULL deliverydays smallint NULL deliveryfee double precision NULL deliverynumber integer NULL deliveryregion smallint NULL description varchar(50) NULL expirationdate datetime NULL financialinstitutionnumber varchar(11) NULL foreclosurelossriskcode varchar(1) NULL fundeddate datetime NULL gainorloss double precision NULL interestonly varchar(1) NULL investorid integer NULL investorldid integer NULL issuedate datetime NULL issuetype varchar(1) NULL maxnoterate double precision NULL maxpoolaccrualrate double precision NULL mbsmargin double precision NULL midanetexporttype smallint NULL minnoterate double precision NULL minpoolaccrualrate double precision NULL mortgagebackedsecurity varchar(1) NULL multifamily varchar(1) NULL multiissuenumber integer NULL paraveragecoupon double precision NULL paraveragemargin double precision NULL participationpercent smallint NULL payeecode varchar(9) NULL poolcontractcode1 smallint NULL poolcontractcode2 smallint NULL poolcontractcode3 smallint NULL pooldeliveredflag varchar(1) NULL poolfundedflag varchar(1) NOT NULL poolmaturitydate datetime NULL poolnumber varchar(20) NOT NULL poolterm smallint NULL pooltype varchar(2) NULL premiumfactor double precision NULL price double precision NULL purchasedocumentcode varchar(1) NULL remittanceday smallint NULL roundingfeaturecode smallint NULL securitychangedate datetime NULL securityratemargin double precision NULL sellernumber integer NULL servicefee double precision NULL servicerid integer NULL servicerldid integer NULL servicernumber integer NULL standardlookbackdays smallint NULL submissiontype smallint NULL taxpoolid varchar(9) NULL threshold double precision NULL ttlgrossprofit double precision NULL usebuyupdown smallint NULL weightedaveragecoupon double precision NULL weightedaveragemargin double precision NULL weightedaverageprice double precision NULL the table this-name has a column this-column with type this-type this-null/not-null ======================================================================================== some-name1 is less than some-name2 ------------------------------------------------------ that-name1 is placed alphabetically before that-name2