FilesExpand file tree

 master

/

00-test.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

22 lines (20 loc) · 648 Bytes

 master

/

00-test.sql

Top

File metadata and controls

• Code
• Blame

22 lines (20 loc) · 648 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

DROP TABLE phone IF EXISTS;

DROP TABLE person IF EXISTS;

CREATE TABLE person (

id integer GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,

username varchar(255) NOT NULL,

first_name varchar(255) NOT NULL,

last_name varchar(255) NOT NULL,

create_date datetime NOT NULL,

update_date timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,

UNIQUE (username)

);

CREATE TABLE phone (

id integer GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,

phone_number varchar(30) NOT NULL,

phone_type integer NOT NULL,

person_id integer NOT NULL,

create_date datetime NOT NULL,

FOREIGN KEY (person_id) REFERENCES person(id),

UNIQUE (phone_number)

);