Changes between Version 3 and Version 4 of phase0
- Timestamp:
- 03/06/24 23:53:57 (7 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
phase0
v3 v4 2 2 ---- 3 3 4 create table users 5 ( 6 id bigserial primary key, 7 first_name varchar(255), 8 last_name varchar(255), 9 phone_number varchar(255), 10 email varchar(255) unique, 11 password varchar(255), 12 role varchar(255) 13 ); 4 create table users\\ 5 (\\ 6 id bigserial primary key,\\ 7 first_name varchar(255),\\ 8 last_name varchar(255),\\ 9 phone_number varchar(255),\\ 10 email varchar(255) unique,\\ 11 password varchar(255),\\ 12 role varchar(255)\\ 13 );\\ 14 14 15 15 ---- 16 16 17 create table address 17 create table address\\ 18 18 ( 19 id bigserial primary key, 20 address varchar(255), 21 user_id bigint, 22 foreign key (user_id) references users (id) 23 on delete cascade 24 on update cascade 25 ); 19 id bigserial primary key,\\ 20 address varchar(255),\\ 21 user_id bigint,\\ 22 foreign key (user_id) references users (id)\\ 23 on delete cascade\\ 24 on update cascade\\ 25 );\\ 26 26 27 27 ----