-
Notifications
You must be signed in to change notification settings - Fork 0
Schema
Gargar77 edited this page Sep 14, 2020
·
10 revisions
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
name | string | not null |
website | string | |
created_at | datetime | not null |
updated_at | datetime | not null |
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
company_id | integer | not null, foreign key |
first_name | string | not null |
last_name | string | not null |
phone | string | not null |
string | not null,indexed | |
password_digest | string | not null |
session_token | string | not null, indexed |
role | string | not null |
created_at | string | not null |
updated_at | string | not null |
- comany_id references companies
column name | data type | details |
---|---|---|
id | integer | not null |
company_id | integer | not null, foreign key |
name | string | not null |
address | string | not null, indexed |
primary_contact_name | string | not null, indexed |
primary_contact_phone | string | not null |
monday_cleaning | boolean | not null |
tuesday_cleaning | boolean | not null |
wednesday_cleaning | boolean | not null |
thursday_cleaning | boolean | not null |
friday_cleaning | boolean | not null |
saturday_cleaning | boolean | not null |
sunday_cleaning | boolean | not null |
cleaning_timeframe_start | time | |
cleaning_timeframe_end | time | |
created_at | datetime | not null |
updated_at | datetime | not null |
- company_id references companies
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
account_id | integer | not null, foreign key |
user_id | integer | not null, foreign_key |
- a joins table to track employees to a specific account
- account_id references accounts
- user_id references users
column name | data type | details |
---|---|---|
uploader_id | integer | not null |
account_id | integer | not null |
link | text | not null |
- this table handles uploaded content by user from a specific account
- uploader_id references users
- account_id references accounts