diff options
Diffstat (limited to 'res/sql/tables/pg_ddl.sql')
-rw-r--r-- | res/sql/tables/pg_ddl.sql | 113 |
1 files changed, 113 insertions, 0 deletions
diff --git a/res/sql/tables/pg_ddl.sql b/res/sql/tables/pg_ddl.sql new file mode 100644 index 0000000..0d8b17c --- /dev/null +++ b/res/sql/tables/pg_ddl.sql | |||
@@ -0,0 +1,113 @@ | |||
1 | -- Generated by Oracle SQL Developer Data Modeler 4.0.2.840 | ||
2 | -- at: 2015-01-25 15:20:45 CET | ||
3 | -- site: Oracle Database 11g | ||
4 | -- type: Oracle Database 11g | ||
5 | |||
6 | |||
7 | |||
8 | |||
9 | CREATE TABLE bids | ||
10 | ( | ||
11 | uuid VARCHAR(36) NOT NULL, | ||
12 | item_uuid VARCHAR(36) NOT NULL, | ||
13 | user_uuid VARCHAR(36) NOT NULL, | ||
14 | bid_date TIMESTAMP WITH TIME ZONE NOT NULL, | ||
15 | offer NUMERIC(8, 2) NOT NULL | ||
16 | ); | ||
17 | ALTER TABLE bids ADD CONSTRAINT bids_PK PRIMARY KEY (uuid); | ||
18 | |||
19 | CREATE TABLE charges | ||
20 | ( | ||
21 | uuid VARCHAR(36) NOT NULL, | ||
22 | start_date TIMESTAMP WITH TIME ZONE NOT NULL, | ||
23 | end_date TIMESTAMP WITH TIME ZONE NOT NULL, | ||
24 | fee NUMERIC(8, 2) NOT NULL, | ||
25 | rate NUMERIC(8, 2) NOT NULL | ||
26 | ); | ||
27 | ALTER TABLE charges ADD CONSTRAINT charges_PK PRIMARY KEY (uuid); | ||
28 | |||
29 | CREATE TABLE items | ||
30 | ( | ||
31 | uuid VARCHAR(36) NOT NULL, | ||
32 | user_uuid VARCHAR(36) NOT NULL, | ||
33 | start_date TIMESTAMP WITH TIME ZONE NOT NULL, | ||
34 | end_date TIMESTAMP WITH TIME ZONE NOT NULL, | ||
35 | item_name VARCHAR(20) NOT NULL, | ||
36 | short_desc VARCHAR(30) NOT NULL, | ||
37 | long_desc TEXT NOT NULL, | ||
38 | initial_price NUMERIC(8, 2) NOT NULL | ||
39 | ); | ||
40 | ALTER TABLE items ADD CONSTRAINT items_PK PRIMARY KEY (uuid); | ||
41 | |||
42 | CREATE TABLE transactions | ||
43 | ( | ||
44 | uuid VARCHAR(36) NOT NULL, | ||
45 | user_uuid VARCHAR(36) NOT NULL, | ||
46 | transaction_date TIMESTAMP WITH TIME ZONE NOT NULL, | ||
47 | amount NUMERIC(8, 2) NOT NULL, | ||
48 | label VARCHAR(255) NOT NULL | ||
49 | ); | ||
50 | ALTER TABLE transactions ADD CONSTRAINT transactions_PK PRIMARY KEY (uuid); | ||
51 | |||
52 | CREATE TABLE users | ||
53 | ( | ||
54 | uuid VARCHAR(36) NOT NULL, | ||
55 | username VARCHAR(20) NOT NULL, | ||
56 | email VARCHAR(255) NOT NULL, | ||
57 | user_password VARCHAR(255) NOT NULL, | ||
58 | creation_date TIMESTAMP WITH TIME ZONE NOT NULL, | ||
59 | first_name VARCHAR(255) NOT NULL, | ||
60 | last_name VARCHAR(255) NOT NULL, | ||
61 | country_code VARCHAR(2) NOT NULL, | ||
62 | postal_code VARCHAR(20) NOT NULL, | ||
63 | address VARCHAR(255) NOT NULL, | ||
64 | phone VARCHAR(20) NOT NULL, | ||
65 | birthdate TIMESTAMP WITH TIME ZONE NOT NULL | ||
66 | ); | ||
67 | ALTER TABLE users ADD CONSTRAINT users_PK PRIMARY KEY (uuid); | ||
68 | |||
69 | ALTER TABLE bids ADD CONSTRAINT bids_items_FK FOREIGN KEY (item_uuid) REFERENCES items (uuid); | ||
70 | |||
71 | ALTER TABLE bids ADD CONSTRAINT bids_users_FK FOREIGN KEY (user_uuid) REFERENCES users (uuid); | ||
72 | |||
73 | ALTER TABLE items ADD CONSTRAINT items_users_FK FOREIGN KEY (user_uuid) REFERENCES users (uuid); | ||
74 | |||
75 | ALTER TABLE transactions ADD CONSTRAINT transactions_users_FK FOREIGN KEY (user_uuid) REFERENCES users (uuid); | ||
76 | |||
77 | |||
78 | -- Oracle SQL Developer Data Modeler Summary Report: | ||
79 | -- | ||
80 | -- CREATE TABLE 5 | ||
81 | -- CREATE INDEX 0 | ||
82 | -- ALTER TABLE 9 | ||
83 | -- CREATE VIEW 0 | ||
84 | -- CREATE PACKAGE 0 | ||
85 | -- CREATE PACKAGE BODY 0 | ||
86 | -- CREATE PROCEDURE 0 | ||
87 | -- CREATE FUNCTION 0 | ||
88 | -- CREATE TRIGGER 0 | ||
89 | -- ALTER TRIGGER 0 | ||
90 | -- CREATE COLLECTION TYPE 0 | ||
91 | -- CREATE STRUCTURED TYPE 0 | ||
92 | -- CREATE STRUCTURED TYPE BODY 0 | ||
93 | -- CREATE CLUSTER 0 | ||
94 | -- CREATE CONTEXT 0 | ||
95 | -- CREATE DATABASE 0 | ||
96 | -- CREATE DIMENSION 0 | ||
97 | -- CREATE DIRECTORY 0 | ||
98 | -- CREATE DISK GROUP 0 | ||
99 | -- CREATE ROLE 0 | ||
100 | -- CREATE ROLLBACK SEGMENT 0 | ||
101 | -- CREATE SEQUENCE 0 | ||
102 | -- CREATE MATERIALIZED VIEW 0 | ||
103 | -- CREATE SYNONYM 0 | ||
104 | -- CREATE TABLESPACE 0 | ||
105 | -- CREATE USER 0 | ||
106 | -- | ||
107 | -- DROP TABLESPACE 0 | ||
108 | -- DROP DATABASE 0 | ||
109 | -- | ||
110 | -- REDACTION POLICY 0 | ||
111 | -- | ||
112 | -- ERRORS 0 | ||
113 | -- WARNINGS 0 | ||