Boolgram_db

comment

id

user_fk : varchar(200);

post_fk : varchar(200);

body : text;

data_sending : timestamp

users

id

name : varchar(200);

email : varchar(100);

email_verified_at : timestamp;

birthday : date;

nation

tel :

rec_promotional_mess :tinyint;

type : enum(UR, UR)

created_at : timestamp default current_timestamp;

updated_at : datetime default current_timestamp on update current_timestamp;

post

id

user_fk : varchar(200);

summury_title : varchar(200);

content: text;

visible : tinyint;

*

1

1

*

1

1

*

stories

id

user_fk : varchar(200);​​​​

summury_title : varchar(200);

content: text;

visible : tinyint;

*

view

id

user_fk : varchar(200);​​​​

summury_title : varchar(200);

content: text;

visible : tinyint;

*

1

*

1

*

hashtag_post

post_fk :

hashtag_fk :

created_at : timestamp default current_timestamp;

hashtag

id

name: varchar(200);

LIKE

id

user_fk : varchar(200);

post_fk : varchar(200);

data_sending : timestamp

*

1

*

*

1

= PIVOT TABLER