DB BOOLBNB

users

id

name : varchar(200);

email : varchar(100);

email_verified_at : timestamp;

birthday : date;

nation

tel :

rec_promotional_mess :tinyint;

type : enum(UR, URA)

created_at : timestamp default current_timestamp;

updated_at : datetime default current_timestamp on update current_timestamp;

-----------------------------------

uncertain

api_token

properties

id

user_fk : varchar(200);

summury_title : varchar(200);

rooms : smallint;

beds : smallint;

bathrooms : smallint;

Square_meters : smallint;

Image : text;

service : text;

visible : tinyint;

messages

id

property_fk : varchar(200);

body : text;

sender_email : varchar(100);

data_sending : timestamp;

1

*

= PIVOT TABLE

*

1

1

*

full_address_properties

property_fk :

state: varchar(200);

city: varchar(200);

zip : smallint;

address: varchar(200);

number: smallint;

lat: decimal('latitude', 10, 8);

lon: decimal('longitude', 11, 8);​​​​​​

1

1

VIEW

property_fk :

ip_device : varchar(100);

created_at : timestamp default current_timestamp;

​​​​​

1

1

sponsors

id

price : decimal(8, 2) NOT NULL,

hours : smallint;

properies_sponsors

property_fk :

sponsor_fk :

created_at : timestamp default current_timestamp;

​​​​​​

*

*