Table 2: The Logical Model: Column Descriptions Arranged in Alphabetic Order by Table Name

Table Name Column Name Data Type Length Key Status Required? Index? Default Value Check Constraint Column Description
Article ArticleID Integer 4 Pkey Yes Yes     Unique identifier for each article
  PublicationID Integer 2 Fkey No Yes     Link back to table Publication, each article can be related to a Publication
  ArticleTitle Text 100   Yes       Article title
  DateSubmitted Date     Yes       Date article was submitted
  NbrWords Integer 4           Number of words in the article
Article_ Category ArticleCatID Integer 4 Pkey Yes Yes     Unique identifier for each category of article
  ArticleCatDscr Text 30           Description of the article category
Author PersonID Integer 4 Pkey, fkey Yes Yes     Unique identifier for each author, links back to table Person
  PayToOrderOf Text 50       PersonID   Name of entity, person or company, to whom the paycheck should be made out
  PayToTaxID Text 15   Eventually Yes     SSN or TaxID number to which the paycheck is attached
  PayToAddress Text 60           Full mailing address to which the paycheck will be mailed
Author_ Article_ Pay   PersonID   Integer   4 Pkey, fkey   Yes   Yes     Author who is paid for this article, foreign key link back to tables Author and Person
  ArticleID Integer 4 Pkey, fkey Yes Yes     Article that is paid for, foreign key link back to table Article
  DatePaid Date             Date this article was paid for
  AmountPaid Currency             Amount paid for this article
Author_ Article_ Write   PersonID   Integer   4 Pkey, fkey   yes   Yes     Author who wrote article, foreign key link back to tables Author and Person
  ArticleID Integer 4 Pkey, fkey yes Yes     Article that was written, foreign key link back to table Article
  SingleAuthor Boolean 1       Y   Was this article written by one person?
  LeadAuthor Text 1           If multiple authors, is this the lead author?
Emp_ Skill PersonID Integer 4 Pkey, fkey Yes Yes     Unique identifier for each employee, link back to table Employee and table Person
  SkillID Integer 2 Pkey, fkey Yes Yes     Unique identifier for each skill, link back to table Skill
  SkillLevel Text 20   Yes       Level of this skill achieved by this employee, typically
Employee PersonID Integer 4 Pkey, fkey Yes Yes     Unique identifier for each person, link back to table Person
  EmpSSN Text 12   Eventually Yes     SSN for employee, required by tax law
  HireDate Date     Yes       Date (mm/dd/yyyy) that employee was hired and began work
Person PersonID Int-auto counter 4 Pkey Yes Yes     Unique identifier for each person
  FirstName Text 20   Yes Yes     Person's first or given name
  Minit Text 1           Initial of person's middle name
  LastName Text 30   Yes Yes     Person's last or surname, family name
    Address   Text   60           Full residence address, including street number & name, city, state code, & zip code
  Phone Text 30     Maybe     Contact phone number for this person, include area code
  Email Text 60     Maybe     Contact email address for this person
Person_ Publisher PersonID Integer 4 Pkey, fkey Yes Yes     Person who is working with this publisher, foreign key link back to table Person
  PubID Integer 4 Pkey, fkey Yes Yes     Publisher who has contracted this person, foreign key link back to table Publisher
  ContractDate Date       Maybe     Date contract was signed
  Contract Duration Text 12           Length of time of the contract
  Contract RenewalDate Date       Maybe     Date contract needs to be renewed
Pub_ Category PubCatID Integer 4 Pkey Yes Yes     Primary key, unique identifier for each category of publication
  PubCatDscr Text 30   Yes       Description of the publication category
Publ_ Activity PublActivityID Integer 4 Pkey Yes Yes     Primary key, unique identifier for each instance of Publ_Activity
  PersonID Integer 4 Fkey Yes Yes     Foreign key link back to table Employee
  TaskID Integer 4 Fkey Yes Yes     Foreign key link back to table Task
  PublicationID Integer 4 Fkey Yes Yes     Foreign key link back to table Publication
  ArticleID Integer 4 Fkey Yes Yes     Foreign key link back to table Article
  DateStart Date     Yes Yes     Date this task started
  DateEnd Date             Date this task was completed
Publication PublicationID Integer 4 Pkey Yes Yes     Primary key, unique identifier for each publication
  PubID Integer 4 Fkey Yes Yes     Foreign key, link back to table Publisher
  PubCatID Integer 4 Fkey Yes Yes     Foreign key, link back to table Pub_Category
  Publication Name Text 50   Yes       Descriptive name of the publication
Publication _Store PublicationID Integer 4 Pkey, fkey Yes Yes     Which publication was sent to which store, foreign key link back to table Publication
  StoreID Integer 4 Pkey, fkey Yes Yes     Which store received which publication, foreign key link back to table Store
  SendOrReturn Text 1       S, R, null   Was this a send or a return shipment?
  DateOfTransfer Date     Yes Yes     Date this shipment was sent out
  Quantity SentReturned Integer 4           Volume sent or returned
  Unit SentReturned Text 10           Unit of volume sent or returned
Publisher PubID Integer 4 Pkey Yes Yes     Primary key, unique identifier for each publisher
  PubName Text 50   Yes Yes     Name of the publisher
  PubAddress Text 60           Publisher's address
Sale SaleID Integer 4 Pkey Yes Yes     Primary key, unique identifier for each sale
  StoreID Integer 4 Fkey Yes Yes     Foreign key, link back to table Store
  DateTimeSale Datetime     Yes Yes     Date and time this sale took place
  TotalTax Currency             Total amount of sales tax charged
  ShippingCost Currency             Total amount of shipping
  TotalSale Currency             Total amount of sale
Sale_Item ItemID Integer 4 Pkey Yes Yes     Primary key, unique identifier for each item sold
  SaleID Integer 4 Fkey Yes Yes     Foreign key link back to table Sale
  PublicationID Integer 4 Fkey Yes Yes     Foreign key link back to table Publication
  Quantity Integer 2           Number of items sold
  ItemPrice Currency             Per item sale price
Skill SkillID Int-auto counter 4 pkey Yes Yes     Primary key, unique identifier for each skill
  SkillDscr Text 50   Yes Yes     Description of each skill
Store StoreID Integer 4 Pkey Yes Yes     Primary key, unique identifier for each store
  StoreAddress Text 60           Address of the store
  StorePhone Text 30           Phone number for the store
Task TaskID Integer 4 Pkey Yes Yes     Primary key, unique identifier for each task
  SkillID Integer 4 Fkey Yes Yes     Foreign key, link back to table Skill
  TaskDscr Text 50   Yes Yes     Description of the task