Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- | Accounts | CREATE TABLE `Accounts` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `birth_day` date NOT NULL,
- `first_name` varchar(255) NOT NULL,
- `last_name` varchar(255) NOT NULL,
- `mobile_phone` varchar(255) NOT NULL,
- `password` varchar(255) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `mobile_phone` (`mobile_phone`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
- | Mails | CREATE TABLE `Mails` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) NOT NULL,
- `registration_date` date NOT NULL,
- `user_id` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- KEY `FK46AC17C61ACE59B` (`user_id`),
- CONSTRAINT `FK46AC17C61ACE59B` FOREIGN KEY (`user_id`) REFERENCES `Accounts` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement