| parent | column | definition | comment |
|---|---|---|---|
| animals | NAME | Char NULL | |
| animals | SIZE | Int NULL | |
| animals | WEIGHT | Int NULL | |
| animals | AREA | Char NULL | |
| animals | BMP | Image NULL | |
| biolife | Species_No | Float NOT NULL | |
| biolife | Category | Char NULL | |
| biolife | Common_Name | Char NULL | |
| biolife | Species_Name | Char NULL | |
| biolife | Length__cm_ | Float NULL | |
| biolife | Length_In | Float NULL | |
| biolife | Notes | NText NULL | |
| biolife | Graphic | Image NULL | |
| clients | LAST_NAME | Char NULL | |
| clients | FIRST_NAME | Char NULL | |
| clients | ACCT_NBR | Float NULL | |
| clients | ADDRESS_1 | Char NULL | |
| clients | CITY | Char NULL | |
| clients | STATE | Char NULL | |
| clients | ZIP | Char NULL | |
| clients | TELEPHONE | Char NULL | |
| clients | DATE_OPEN | SmallDateTime NULL | |
| clients | SS_NUMBER | Float NULL | |
| clients | PICTURE | Char NULL | |
| clients | BIRTH_DATE | SmallDateTime NULL | |
| clients | RISK_LEVEL | Char NULL | |
| clients | OCCUPATION | Char NULL | |
| clients | OBJECTIVES | Char NULL | |
| clients | INTERESTS | VarChar NULL | |
| clients | IMAGE | Image NULL | |
| country | Name | Char NOT NULL | |
| country | Capital | Char NULL | |
| country | Continent | Char NULL | |
| country | Area | Float NULL | |
| country | Population | Float NULL | |
| custoly | CustNo | Int NOT NULL | |
| custoly | Last_Name | Char NULL | |
| custoly | First_Name | Char NULL | |
| custoly | VIP_Status | Char NULL | |
| custoly | Address1 | Char NULL | |
| custoly | Address2 | Char NULL | |
| custoly | City | Char NULL | |
| custoly | State_Prov | Char NULL | |
| custoly | Post_Code | Char NULL | |
| custoly | Country | Char NULL | |
| custoly | Phone | Char NULL | |
| custoly | Fax | Char NULL | |
| custoly | Char NULL | ||
| custoly | Remarks | NText NULL | |
| customer | CustNo | Float NOT NULL | |
| customer | Company | Char NULL | |
| customer | Addr1 | Char NULL | |
| customer | Addr2 | Char NULL | |
| customer | City | Char NULL | |
| customer | State | Char NULL | |
| customer | Zip | Char NULL | |
| customer | Country | Char NULL | |
| customer | Phone | Char NULL | |
| customer | FAX | Char NULL | |
| customer | TaxRate | Float NULL | |
| customer | Contact | Char NULL | |
| customer | LastInvoiceDate | DateTime NULL | |
| employee | EmpNo | Int NOT NULL | |
| employee | LastName | Char NULL | |
| employee | FirstName | Char NULL | |
| employee | PhoneExt | Char NULL | |
| employee | HireDate | DateTime NULL | |
| employee | Salary | Float NULL | |
| events | EventNo | Int NOT NULL | |
| events | VenueNo | Int NULL | |
| events | Event_Name | Char NULL | |
| events | Event_Date | SmallDateTime NULL | |
| events | Event_Time | DateTime NULL | |
| events | Event_Description | NText NULL | |
| events | Ticket_price | Money NULL | |
| events | Event_Photo | Image NULL | |
| holdings | ACCT_NBR | Float NULL | |
| holdings | SYMBOL | Char NULL | |
| holdings | SHARES | Float NULL | |
| holdings | PUR_PRICE | Float NULL | |
| holdings | PUR_DATE | SmallDateTime NULL | |
| industry | IND_CODE | Int NULL | |
| industry | IND_NAME | Char NULL | |
| industry | LONG_NAME | Char NULL | |
| items | OrderNo | Float NOT NULL | |
| items | ItemNo | Float NOT NULL | |
| items | PartNo | Float NULL | |
| items | Qty | Int NULL | |
| items | Discount | Float NULL | |
| master | SYMBOL | Char NULL | |
| master | CO_NAME | Char NULL | |
| master | EXCHANGE | Char NULL | |
| master | CUR_PRICE | Float NULL | |
| master | YRL_HIGH | Float NULL | |
| master | YRL_LOW | Float NULL | |
| master | P_E_RATIO | Float NULL | |
| master | BETA | Float NULL | |
| master | PROJ_GRTH | Float NULL | |
| master | INDUSTRY | Int NULL | |
| master | PRICE_CHG | Int NULL | |
| master | SAFETY | Int NULL | |
| master | RATING | Char NULL | |
| master | RANK | Float NULL | |
| master | OUTLOOK | Int NULL | |
| master | RCMNDATION | Char NULL | |
| master | RISK | Char NULL | |
| nextcust | NewCust | Float NULL | |
| nextitem | NewKey | Float NULL | |
| nextord | NewKey | Float NULL | |
| orders | OrderNo | Float NOT NULL | |
| orders | CustNo | Float NOT NULL | |
| orders | SaleDate | DateTime NULL | |
| orders | ShipDate | DateTime NULL | |
| orders | EmpNo | Int NOT NULL | |
| orders | ShipToContact | Char NULL | |
| orders | ShipToAddr1 | Char NULL | |
| orders | ShipToAddr2 | Char NULL | |
| orders | ShipToCity | Char NULL | |
| orders | ShipToState | Char NULL | |
| orders | ShipToZip | Char NULL | |
| orders | ShipToCountry | Char NULL | |
| orders | ShipToPhone | Char NULL | |
| orders | ShipVIA | Char NULL | |
| orders | PO | Char NULL | |
| orders | Terms | Char NULL | |
| orders | PaymentMethod | Char NULL | |
| orders | ItemsTotal | Money NULL | |
| orders | TaxRate | Float NULL | |
| orders | Freight | Money NULL | |
| orders | AmountPaid | Money NULL | |
| parts | PartNo | Float NOT NULL | |
| parts | VendorNo | Float NULL | |
| parts | Description | Char NULL | |
| parts | OnHand | Float NULL | |
| parts | OnOrder | Float NULL | |
| parts | Cost | Money NULL | |
| parts | ListPrice | Money NULL | |
| reservat | ResNo | Int NOT NULL | |
| reservat | EventNo | Int NULL | |
| reservat | CustNo | Int NULL | |
| reservat | NumTickets | Int NULL | |
| reservat | Amt_Paid | Money NULL | |
| reservat | Pay_Method | Char NULL | |
| reservat | Card_No | Char NULL | |
| reservat | Card_Exp | SmallDateTime NULL | |
| reservat | Pay_Notes | NText NULL | |
| reservat | Purge_Date | SmallDateTime NULL | |
| reservat | Paid | Bit NULL | |
| vendors | VendorNo | Float NOT NULL | |
| vendors | VendorName | Char NULL | |
| vendors | Address1 | Char NULL | |
| vendors | Address2 | Char NULL | |
| vendors | City | Char NULL | |
| vendors | State | Char NULL | |
| vendors | Zip | Char NULL | |
| vendors | Country | Char NULL | |
| vendors | Phone | Char NULL | |
| vendors | FAX | Char NULL | |
| vendors | Preferred | Bit NULL | |
| venues | VenueNo | Int NOT NULL | |
| venues | Venue | Char NULL | |
| venues | Capacity | Int NULL | |
| venues | Venue_Map | Image NULL | |
| venues | Remarks | NText NULL |