create table FOLLOWER
(
ID BIGINT auto_increment
primary key,
TO_ID BIGINT,
FROM_ID BIGINT,
constraint FK253K7981XV64OVPJMBV39RAVM
foreign key (FROM_ID) references USER (USER_ID),
constraint FK7L8YU2TGL8COEPDQ7Q6NL2ULG
foreign key (TO_ID) references USER (USER_ID)
);
create table PIN
(
ID INT auto_increment
primary key,
CREATE_DATE TIMESTAMP,
MODIFIED_DATE TIMESTAMP,
COUNT INT,
CONTENT TEXT not null,
PATH VARCHAR(255),
ROLE VARCHAR(255) not null,
TITLE VARCHAR(50) not null
constraint UK_APP1KTRTU08LNVXHBSQBI6R2R
unique,
USER_ID BIGINT,
constraint FKG9F9IV6QP02XP8QYK40QJQ00O
foreign key (USER_ID) references USER (USER_ID)
);
create table USER ( USER_ID BIGINT auto_increment primary key, CREATE_DATE TIMESTAMP, MODIFIED_DATE TIMESTAMP, EMAIL VARCHAR(255), PASSWORD VARCHAR(20), PATH VARCHAR(255), USERNAME VARCHAR(30) );
create table FOLLOWER ( ID BIGINT auto_increment primary key, TO_ID BIGINT, FROM_ID BIGINT, constraint FK253K7981XV64OVPJMBV39RAVM foreign key (FROM_ID) references USER (USER_ID), constraint FK7L8YU2TGL8COEPDQ7Q6NL2ULG foreign key (TO_ID) references USER (USER_ID) );
create table PIN ( ID INT auto_increment primary key, CREATE_DATE TIMESTAMP, MODIFIED_DATE TIMESTAMP, COUNT INT, CONTENT TEXT not null, PATH VARCHAR(255), ROLE VARCHAR(255) not null, TITLE VARCHAR(50) not null constraint UK_APP1KTRTU08LNVXHBSQBI6R2R unique, USER_ID BIGINT, constraint FKG9F9IV6QP02XP8QYK40QJQ00O foreign key (USER_ID) references USER (USER_ID) );
create table COMMENT ( COMMENT_ID BIGINT auto_increment primary key, CREATE_DATE TIMESTAMP, MODIFIED_DATE TIMESTAMP, CONTENT VARCHAR(1000) not null, PIN_ID INT, USER_ID BIGINT, constraint FK8KCUM44FVPUPYW6F5BACCX25C foreign key (USER_ID) references USER (USER_ID), constraint FKMK6NAITTWCDKKLM9R29NL6FF1 foreign key (PIN_ID) references PIN (ID) );
create table LIKE_IMAGE ( LIKES_ID BIGINT auto_increment primary key, IMAGE_ID INT, USER_ID BIGINT, constraint FK76KX7LXCFJN1EN9D1LHE7JC4L foreign key (IMAGE_ID) references PIN (ID), constraint FKREH9KIUHU5VITBM9Y1V8NOVCV foreign key (USER_ID) references USER (USER_ID) );