Changes between Version 1 and Version 2 of DatabaseCreation

Timestamp:

04/12/26 21:01:39 (3 weeks ago)

Author:

231133

Comment:

--

DatabaseCreation

@@ -5 +5 @@
 DDL-от беше генериран од страна на Visual Paradigm, испробан локално и дополнет со constraints. Потоа, направивме pg_dump и го импортиравме на нашата remote база за предметот.
 
-== 2. Дел од кодот ==
+== 2. Поважни делови од кодот ==
 
+=== Create table
+
+{{{ 
 CREATE TABLE user_app (
     user_id bigint NOT NULL,
@@ -14 +17 @@
     CONSTRAINT chk_email_format CHECK (((email)::text ~~ '%@%.%'::text))
 );
+}}}
 
 CREATE TABLE order_cart (
@@ -25 +29 @@
 );
 
+{{{
 CREATE TABLE attribute (
     name text NOT NULL,
@@ -32 +37 @@
     is_required boolean NOT NULL
 );
+}}}
 
+{{{
 CREATE TABLE payment (
     order_id bigint NOT NULL,
@@ -43 +50 @@
     CONSTRAINT chk_payment_amount CHECK ((amount_paid >= (0)::numeric))
 );
+}}}
 
+=== Constraints
+
+{{{
 ALTER TABLE ONLY waitlist_entry
     ADD CONSTRAINT fk_waitlist_user FOREIGN KEY (user_id) REFERENCES public.user_app(user_id) ON UPDATE CASCADE ON DELETE CASCADE;
+}}}
 
+{{{
 ALTER TABLE ONLY ticket
     ADD CONSTRAINT fk_ticket_seat FOREIGN KEY (seat_id) REFERENCES public.seat(seat_id) ON UPDATE CASCADE ON DELETE SET NULL;
+}}}
 
+{{{
 ALTER TABLE ONLY payment_method
     ADD CONSTRAINT payment_method_method_name_key UNIQUE (method_name);
+}}}
 
 == 3. Резултат ==