Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Companies { ID }
- Accounts { ID }
- Accounts_Companies { ID, Account_ID, Company_ID }
- Customers { ID, Account_ID }
- JobTypes { ID }
- Jobs { ID, Company_ID, Account_ID, Customer_ID, JobType_ID, OutOfRadius (BOOL) }
- CREATE TABLE IF NOT EXISTS `configs` (
- `ID` int(11) NOT NULL AUTO_INCREMENT,
- `Company_ID` int(11) NOT NULL,
- `Account_ID` int(11) DEFAULT NULL,
- `Customer_ID` int(11) DEFAULT NULL,
- `JobType_ID` int(11) DEFAULT NULL,
- `OutOfRadius` tinyint(1) DEFAULT NULL,
- `ConfigKeyA` tinyint(1) DEFAULT NULL,
- `ConfigKeyB` int(5) DEFAULT NULL,
- `ConfigKeyC` tinyint(1) DEFAULT NULL,
- `ConfigKeyD` int(3) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- );
- INSERT INTO configs (Company_ID, Account_ID, ConfigKeyC) VALUES (?, ?, ?)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement