changes.mady.by.user PSMON
Saved on 2018년 Feb 28일
...
방향에따른 구분
CREATE TABLE `group_info` ( `group_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`group_id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(255) COLLATE utf8_bin DEFAULT NULL, `name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `group_id` int(11) DEFAULT NULL, PRIMARY KEY (`user_id`), KEY `FKa36i4ekojwk70bxen390i6tek` (`group_id`), CONSTRAINT `FKa36i4ekojwk70bxen390i6tek` FOREIGN KEY (`group_id`) REFERENCES `group_info` (`group_id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE
TABLE
`group_info` (
`group_id`
int
(11)
NOT
NULL
AUTO_INCREMENT,
`
name
varchar
(255)
COLLATE
utf8_bin
DEFAULT
,
PRIMARY
KEY
(`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2
CHARSET=utf8
=utf8_bin;
user
` (
`user_id`
`email`
(`user_id`),
`FKa36i4ekojwk70bxen390i6tek` (`group_id`),
CONSTRAINT
`FKa36i4ekojwk70bxen390i6tek`
FOREIGN
REFERENCES
`group_info` (`group_id`)