dreampolice
Technical User
Here is what I have for creating a Schema:
- Point of Contact Name
- Point of Contact Phone
- Expert Name
- Expert Phone
- Project Name
- Project Location
On some occasions the Point of Contact Name will be the same person as the Expert Name.
For the Schema I am looking at this:
ContactTable
contact_id -> primary key
firstname -> text data type
lastname -> text data type
phone -> number data type
poc -> boolean data type
expert -> boolean data type
ProjectTable
project_id -> primary key
contact_id -> foreign key
projectName -> text data type
projectLocation -> text data type
Does this sound like the correct direction for this Schema?
- Point of Contact Name
- Point of Contact Phone
- Expert Name
- Expert Phone
- Project Name
- Project Location
On some occasions the Point of Contact Name will be the same person as the Expert Name.
For the Schema I am looking at this:
ContactTable
contact_id -> primary key
firstname -> text data type
lastname -> text data type
phone -> number data type
poc -> boolean data type
expert -> boolean data type
ProjectTable
project_id -> primary key
contact_id -> foreign key
projectName -> text data type
projectLocation -> text data type
Does this sound like the correct direction for this Schema?