provi-backend/tables.sql at master · axpalx/provi-backend · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
CREATE TABLE IF NOT EXISTS User(
	id VARCHAR(255) PRIMARY KEY,
	email VARCHAR(255) NOT NULL,
	password VARCHAR(255) NOT NULL
);

CREATE TABLE IF NOT EXISTS Usercpf (
	id VARCHAR(255) NOT NULL,
	cpf VARCHAR(255) NOT NULL,
  updatedat VARCHAR(255) NOT NULL,
  user_id VARCHAR(255),
  FOREIGN KEY (user_id) REFERENCES User(id)
);

CREATE TABLE IF NOT EXISTS Username (
	id VARCHAR(255) NOT NULL,
	firstname VARCHAR(255) NOT NULL,
  lastname VARCHAR(255) NOT NULL,
  updatedat VARCHAR(255) NOT NULL,
  user_id VARCHAR(255),
  FOREIGN KEY (user_id) REFERENCES User(id)
);

CREATE TABLE IF NOT EXISTS Useraddress (
	id VARCHAR(255) NOT NULL,
	cep VARCHAR(255) NOT NULL,
  street VARCHAR(255) NOT NULL,
  housenumber INT NOT NULL,
  complement VARCHAR(255) NOT NULL,
  city VARCHAR(255) NOT NULL,
  state VARCHAR(255) NOT NULL,
  updatedat VARCHAR(255) NOT NULL,
  user_id VARCHAR(255),
  FOREIGN KEY (user_id) REFERENCES User(id)
);

CREATE TABLE IF NOT EXISTS Userdatebirth (
  id VARCHAR(255) NOT NULL,
	datebirth VARCHAR(255) NOT NULL,
  updatedat VARCHAR(255) NOT NULL,
  user_id VARCHAR(255),
  FOREIGN KEY (user_id) REFERENCES User(id)
);

CREATE TABLE IF NOT EXISTS Userphonenumber (
  id VARCHAR(255) NOT NULL,
	phonenumber BIGINT NOT NULL,
  updatedat VARCHAR(255) NOT NULL,
  user_id VARCHAR(255),
  FOREIGN KEY (user_id) REFERENCES User(id)
);

CREATE TABLE IF NOT EXISTS Userorderedquantity (
  id VARCHAR(255) NOT NULL,
	orderedquantity DECIMAL(10,2) NOT NULL,
  updatedat VARCHAR(255) NOT NULL,
  user_id VARCHAR(255),
  FOREIGN KEY (user_id) REFERENCES User(id)
);