253 lines
18 KiB
SQL
253 lines
18 KiB
SQL
SET search_path TO art;
|
|
|
|
-- SYSTEM ROLE
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ('ART', 'SYSTEM', '000-1234', 'arts@art.com', 1);
|
|
-- STAFF ROLE
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ('Alice', 'Johnson', '650-555-9012', 'alice.johnson@art.com', 1);
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ( 'Karen', 'Park', '206-555-0110', 'karen.park@art.com', 1);
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ( 'Jeese', 'Taylor', '713-555-0106', 'grace.taylor@art.com', 1);
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ( 'James', 'Lee', '206-555-0109', 'james.lee@art.com', 1);
|
|
-- SUPPLIER ROLE
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ('Stephen', 'Alec', '424-546-9312', 'salec@eizel.com', 1);
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ('Henry', 'Martinez', '602-555-0107', 'henry@artsupply.com', 1);
|
|
-- CUSTOMER ROLE
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ('Carol', 'White', '212-555-0102', 'carol.white@mail.com', 1);
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ('Bob', 'Smith', '212-555-0101', 'bob.smith@mail.com', 1);
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ('David', 'Brown', '312-555-0103', 'david.brown@mail.com', 1);
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ('Emma', 'Davis', '312-555-0104', 'emma.davis@mail.com', 1);
|
|
INSERT INTO CONTACT ( FIRST_NAME, LAST_NAME, PHONE_NO, EMAIL, MODIFIED_BY) VALUES ('Frank', 'Wilson', '713-555-0105', 'frank.wilson@mail.com', 1);
|
|
|
|
INSERT INTO ZIP (ZIP, CITY, STATE) VALUES ('10001', 'New York', 'NY');
|
|
INSERT INTO ZIP (ZIP, CITY, STATE) VALUES ('90210', 'Beverly Hills', 'CA');
|
|
INSERT INTO ZIP (ZIP, CITY, STATE) VALUES ('94027', 'Atherton', 'CA');
|
|
INSERT INTO ZIP (ZIP, CITY, STATE) VALUES ('90211', 'Los Angeles', 'CA');
|
|
INSERT INTO ZIP (ZIP, CITY, STATE) VALUES ('60601', 'Chicago', 'IL');
|
|
INSERT INTO ZIP (ZIP, CITY, STATE) VALUES ('77001', 'Houston', 'TX');
|
|
INSERT INTO ZIP (ZIP, CITY, STATE) VALUES ('85001', 'Phoenix', 'AZ');
|
|
INSERT INTO ZIP (ZIP, CITY, STATE) VALUES ('98101', 'Seattle', 'WA');
|
|
INSERT INTO ZIP (ZIP, CITY, STATE) VALUES ('02101', 'Boston', 'MA');
|
|
INSERT INTO ZIP (ZIP, CITY, STATE) VALUES ('33101', 'Miami', 'FL');
|
|
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP) VALUES (1, '789 Oak St, suite 10', '94027');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP) VALUES (2, '789 Oak St, suite 15', '94027');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP) VALUES (3, '789 Oak St, suite 1', '94027');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP) VALUES (4, '789 Oak St, suite 5', '94027');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP) VALUES (5, '789 Oak St, suite 15', '94027');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP) VALUES (6, '890 Venue Rd', '90210');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP) VALUES (7, '200 Sunset Blvd', '90210');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP) VALUES (8, '100 Broadway', '10001');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP) VALUES (9, '300 Michigan Ave', '60601');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP) VALUES (10, '400 Main St', '77001');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP ) VALUES (11, '500 Central Ave', '85001');
|
|
INSERT INTO ADDRESS (FK_CONTACT_ID, STREET, ZIP ) VALUES (12, '600 Pike St', '98101');
|
|
|
|
-- SYSTEMPROFILE
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (1, TRUE, 1);
|
|
-- STAFF PROFILE
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (2, TRUE, 2);
|
|
-- SUPPLIER
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (3, TRUE, 3);
|
|
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (4, TRUE, 1);
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (5, TRUE, 1);
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (6, TRUE, 1);
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (7, TRUE, 1);
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (8, FALSE, 1); -- inactive
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (9, TRUE, 1);
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (10, TRUE, 1);
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (11, TRUE, 1);
|
|
INSERT INTO PROFILE (FK_CONTACT_ID, ACTIVE, MODIFIED_BY) VALUES (12, TRUE, 1);
|
|
|
|
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME, PASSWORDHASH) VALUES (1, 'SYSTEM', NULL);
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (2, 'STAFF');
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (3, 'STAFF');
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (4, 'STAFF');
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (5, 'STAFF');
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (6, 'SUPPLIER');
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (7, 'SUPPLIER');
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (8, 'CUSTOMER'); -- inactive customer
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (9, 'CUSTOMER');
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (10, 'CUSTOMER');
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (11, 'CUSTOMER');
|
|
INSERT INTO USERROLE (FK_PROFILE_ID, ROLENAME) VALUES (12, 'CUSTOMER');
|
|
|
|
INSERT INTO STAFF (FK_PROFILE_ID, POSITION) VALUES (2, 'Director');
|
|
INSERT INTO STAFF (FK_PROFILE_ID, POSITION) VALUES (3, 'Registrar');
|
|
INSERT INTO STAFF (FK_PROFILE_ID, POSITION) VALUES (4, 'Curator');
|
|
INSERT INTO STAFF (FK_PROFILE_ID, POSITION) VALUES (5, 'Art Handler');
|
|
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/helpdoc.pdf'); --DOC ID 1
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/consignment-stephen-crimson-horizon.pdf'); --DOC ID 2
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/consignment-stephen-misty-valley.pdf'); --DOC ID 3
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/consignment-stephen-twisted-form.pdf'); --DOC ID 4
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/consignment-stephen-blue-symmetry.pdf'); --DOC ID 5
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/consignment-henry-urban-solitude.pdf'); --DOC ID 6
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/consignment-henry-earth-vessel.pdf'); --DOC ID 7
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/consignment-henry-quiet-reflection.pdf'); --DOC ID 8
|
|
|
|
-- Stephen — approved
|
|
INSERT INTO AUTHORIZE (AUTHORIZATION_STATUS, FK_CONTACT_ID, FK_DOCUMENT_ID, MODIFIED_BY, AUTHORIZATION_DATE, EXPIRATION_DATE)
|
|
VALUES ('approved', 6, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '1 year');
|
|
-- Stephen — approved
|
|
INSERT INTO AUTHORIZE (AUTHORIZATION_STATUS, FK_CONTACT_ID, FK_DOCUMENT_ID, MODIFIED_BY, AUTHORIZATION_DATE, EXPIRATION_DATE)
|
|
VALUES ('approved', 6, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '1 year');
|
|
-- Stephen — pending ('pending' status path)
|
|
INSERT INTO AUTHORIZE (AUTHORIZATION_STATUS, FK_CONTACT_ID, FK_DOCUMENT_ID, MODIFIED_BY, AUTHORIZATION_DATE, EXPIRATION_DATE)
|
|
VALUES ('pending', 6, 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '1 year');
|
|
-- Stephen — rejected ('rejected' status path)
|
|
INSERT INTO AUTHORIZE (AUTHORIZATION_STATUS, FK_CONTACT_ID, FK_DOCUMENT_ID, MODIFIED_BY, AUTHORIZATION_DATE, EXPIRATION_DATE)
|
|
VALUES ('rejected', 6, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '30 days');
|
|
-- Henry — approved
|
|
INSERT INTO AUTHORIZE (AUTHORIZATION_STATUS, FK_CONTACT_ID, FK_DOCUMENT_ID, MODIFIED_BY, AUTHORIZATION_DATE, EXPIRATION_DATE)
|
|
VALUES ('approved', 7, 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '1 year');
|
|
-- Henry — approved
|
|
INSERT INTO AUTHORIZE (AUTHORIZATION_STATUS, FK_CONTACT_ID, FK_DOCUMENT_ID, MODIFIED_BY, AUTHORIZATION_DATE, EXPIRATION_DATE)
|
|
VALUES ('approved', 7, 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '1 year');
|
|
-- Henry — approved
|
|
INSERT INTO AUTHORIZE (AUTHORIZATION_STATUS, FK_CONTACT_ID, FK_DOCUMENT_ID, MODIFIED_BY, AUTHORIZATION_DATE, EXPIRATION_DATE)
|
|
VALUES ('approved', 7, 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '1 year');
|
|
-- Henry — pending
|
|
INSERT INTO AUTHORIZE (AUTHORIZATION_STATUS, FK_CONTACT_ID, FK_DOCUMENT_ID, MODIFIED_BY, AUTHORIZATION_DATE, EXPIRATION_DATE)
|
|
VALUES ('pending', 7, 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + INTERVAL '180 days');
|
|
-- Henry — expired (EXPIRATION_DATE in the past)
|
|
INSERT INTO AUTHORIZE (AUTHORIZATION_STATUS, FK_CONTACT_ID, FK_DOCUMENT_ID, MODIFIED_BY, AUTHORIZATION_DATE, EXPIRATION_DATE)
|
|
VALUES ('expired', 7, 8, 1, CURRENT_TIMESTAMP - INTERVAL '365 days', CURRENT_TIMESTAMP - INTERVAL '30 days');
|
|
|
|
-- PLAN Documents for exhibition
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/plan-spring-gala-2025.pdf'); -- DOC ID 9
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/plan-summer-exhibit-2025.pdf'); -- DOC ID 10
|
|
INSERT INTO DOCUMENT (DOCUMENT_URL) VALUES ('https://art.com/docs/plan-fall-exhibition-2025.pdf'); -- DOC ID 11
|
|
|
|
-- PLANS
|
|
INSERT INTO PLAN (DESCRIPTION, FK_DOCUMENT_ID, DURATION, PRICE, MODIFIED_BY) VALUES ('Spring Gala Preview', 9, 4, 75.00, 1); -- PLAN_ID 1
|
|
INSERT INTO PLAN (DESCRIPTION, FK_DOCUMENT_ID, DURATION, PRICE, MODIFIED_BY) VALUES ('Spring Gala Standard', 9, 8, 120.00, 1); -- PLAN_ID 2
|
|
INSERT INTO PLAN (DESCRIPTION, FK_DOCUMENT_ID, DURATION, PRICE, MODIFIED_BY) VALUES ('Spring Gala VIP', 9, 12, 250.00, 1); -- PLAN_ID 3
|
|
INSERT INTO PLAN (DESCRIPTION, FK_DOCUMENT_ID, DURATION, PRICE, MODIFIED_BY) VALUES ('Summer Exhibit Basic', 10, 4, 50.00, 1); -- PLAN_ID 4
|
|
INSERT INTO PLAN (DESCRIPTION, FK_DOCUMENT_ID, DURATION, PRICE, MODIFIED_BY) VALUES ('Summer Exhibit Plus', 10, 8, 100.00, 1); -- PLAN_ID 5
|
|
INSERT INTO PLAN (DESCRIPTION, FK_DOCUMENT_ID, DURATION, PRICE, MODIFIED_BY) VALUES ('Summer Exhibit Premium', 10, 16, 200.00, 1); -- PLAN_ID 6
|
|
INSERT INTO PLAN (DESCRIPTION, FK_DOCUMENT_ID, DURATION, PRICE, MODIFIED_BY) VALUES ('Fall Exhibition Access', 11, 4, 60.00, 1); -- PLAN_ID 7
|
|
INSERT INTO PLAN (DESCRIPTION, FK_DOCUMENT_ID, DURATION, PRICE, MODIFIED_BY) VALUES ('Fall Exhibition Full Day',11, 8, 110.00, 1); -- PLAN_ID 8
|
|
INSERT INTO PLAN (DESCRIPTION, FK_DOCUMENT_ID, DURATION, PRICE, MODIFIED_BY) VALUES ('Fall Exhibition Weekend', 11, 24, 180.00, 1); -- PLAN_ID 9
|
|
INSERT INTO PLAN (DESCRIPTION, FK_DOCUMENT_ID, DURATION, PRICE, MODIFIED_BY) VALUES ('Annual Patron Pass', 11, 200, 500.00, 1); -- PLAN_ID 10
|
|
|
|
-- IV 1 — Crimson Horizon
|
|
INSERT INTO INVENTORY (FK_CONTACT_ID, FK_AUTHORIZATION_ID, SKU, PRODUCT_DESCRIPTION, UNIT_COST, LEAD_TIME_DAYS,
|
|
PRODUCT_NAME, UNIT_OF_MEASURE, BASE_PRICE, QUANTITY_AVAILABLE, FK_DOCUMENT_ID)
|
|
VALUES (6, 1, 'ART-S-001',
|
|
'Oil on canvas, abstract expressionism, 24x36', 800.00, 7,
|
|
'Crimson Horizon', 'piece', 1200.00, 5, 2);
|
|
|
|
-- IV 2 — Misty Valley
|
|
INSERT INTO INVENTORY (FK_CONTACT_ID, FK_AUTHORIZATION_ID, SKU,
|
|
PRODUCT_DESCRIPTION, UNIT_COST, LEAD_TIME_DAYS,
|
|
PRODUCT_NAME, UNIT_OF_MEASURE, BASE_PRICE, QUANTITY_AVAILABLE, FK_DOCUMENT_ID)
|
|
VALUES (6, 2, 'ART-S-002',
|
|
'Watercolor on paper, landscape, 18x24', 450.00, 5,
|
|
'Misty Valley', 'piece', 700.00, 5, 3);
|
|
|
|
-- IV 3 — Twisted Form
|
|
INSERT INTO INVENTORY (FK_CONTACT_ID, FK_AUTHORIZATION_ID, SKU,
|
|
PRODUCT_DESCRIPTION, UNIT_COST, LEAD_TIME_DAYS,
|
|
PRODUCT_NAME, UNIT_OF_MEASURE, BASE_PRICE, QUANTITY_AVAILABLE, FK_DOCUMENT_ID)
|
|
VALUES (6, 3, 'ART-S-003',
|
|
'Bronze sculpture, abstract, 12 in height', 1500.00, 14,
|
|
'Twisted Form', 'piece', 2200.00, 5, 4);
|
|
|
|
-- IV 4 — Blue Symmetry
|
|
INSERT INTO INVENTORY (FK_CONTACT_ID, FK_AUTHORIZATION_ID, SKU,
|
|
PRODUCT_DESCRIPTION, UNIT_COST, LEAD_TIME_DAYS,
|
|
PRODUCT_NAME, UNIT_OF_MEASURE, BASE_PRICE, QUANTITY_AVAILABLE, FK_DOCUMENT_ID)
|
|
VALUES (7, 1, 'ART-S-004',
|
|
'Acrylic on canvas, geometric, 30x30', 600.00, 7,
|
|
'Blue Symmetry', 'piece', 950.00, 5, 2);
|
|
|
|
-- IV 5 — Urban Collage
|
|
INSERT INTO INVENTORY (FK_CONTACT_ID, FK_AUTHORIZATION_ID, SKU,
|
|
PRODUCT_DESCRIPTION, UNIT_COST, LEAD_TIME_DAYS,
|
|
PRODUCT_NAME, UNIT_OF_MEASURE, BASE_PRICE, QUANTITY_AVAILABLE, FK_DOCUMENT_ID)
|
|
VALUES (7, 2, 'ART-S-005',
|
|
'Mixed media on board, 20x20', 350.00, 5,
|
|
'Urban Collage', 'piece', 550.00, 6, 3);
|
|
|
|
-- IV 6 — Urban Solitude
|
|
INSERT INTO INVENTORY (FK_CONTACT_ID, FK_AUTHORIZATION_ID, SKU,
|
|
PRODUCT_DESCRIPTION, UNIT_COST, LEAD_TIME_DAYS,
|
|
PRODUCT_NAME, UNIT_OF_MEASURE, BASE_PRICE, QUANTITY_AVAILABLE, FK_DOCUMENT_ID)
|
|
VALUES (6, 6, 'ART-H-001',
|
|
'Photography print, archival, limited ed 1/10', 900.00, 3,
|
|
'Urban Solitude', 'piece', 1500.00, 10, 6);
|
|
|
|
-- IV 7 — Earth Vessel
|
|
INSERT INTO INVENTORY (FK_CONTACT_ID, FK_AUTHORIZATION_ID, SKU,
|
|
PRODUCT_DESCRIPTION, UNIT_COST, LEAD_TIME_DAYS,
|
|
PRODUCT_NAME, UNIT_OF_MEASURE, BASE_PRICE, QUANTITY_AVAILABLE, FK_DOCUMENT_ID)
|
|
VALUES (7, 7, 'ART-H-002',
|
|
'Ceramic vessel, hand-thrown and glazed', 250.00, 10,
|
|
'Earth Vessel', 'piece', 420.00, 8, 7);
|
|
|
|
-- IV 8 — Quiet Reflection
|
|
INSERT INTO INVENTORY (FK_CONTACT_ID, FK_AUTHORIZATION_ID, SKU,
|
|
PRODUCT_DESCRIPTION, UNIT_COST, LEAD_TIME_DAYS,
|
|
PRODUCT_NAME, UNIT_OF_MEASURE, BASE_PRICE, QUANTITY_AVAILABLE, FK_DOCUMENT_ID)
|
|
VALUES (7, 8, 'ART-H-003',
|
|
'Pastel drawing, portrait, 16x20', 300.00, 7,
|
|
'Quiet Reflection','piece', 500.00, 4, 8);
|
|
|
|
-- IV 9 — Neon Dreams
|
|
INSERT INTO INVENTORY (FK_CONTACT_ID, FK_AUTHORIZATION_ID, SKU,
|
|
PRODUCT_DESCRIPTION, UNIT_COST, LEAD_TIME_DAYS,
|
|
PRODUCT_NAME, UNIT_OF_MEASURE, BASE_PRICE, QUANTITY_AVAILABLE, FK_DOCUMENT_ID)
|
|
VALUES (6, 6, 'ART-H-004',
|
|
'Digital print on aluminum, 24x36', 700.00, 5,
|
|
'Neon Dreams', 'piece', 1100.00, 6, 6);
|
|
|
|
-- IV 10 — Woven Stories
|
|
INSERT INTO INVENTORY (FK_CONTACT_ID, FK_AUTHORIZATION_ID, SKU,
|
|
PRODUCT_DESCRIPTION, UNIT_COST, LEAD_TIME_DAYS,
|
|
PRODUCT_NAME, UNIT_OF_MEASURE, BASE_PRICE, QUANTITY_AVAILABLE, FK_DOCUMENT_ID)
|
|
VALUES (6, 7, 'ART-H-005',
|
|
'Textile wall hanging, woven, 36x48', 550.00, 14,
|
|
'Woven Stories', 'piece', 850.00, 5, 7);
|
|
|
|
INSERT INTO EXHIBIT (FK_INVENTORY_ID, FK_PLAN_ID) VALUES (1, 1); -- Crimson Horizon → Spring Preview
|
|
INSERT INTO EXHIBIT (FK_INVENTORY_ID, FK_PLAN_ID) VALUES (2, 2); -- Misty Valley → Spring Standard
|
|
INSERT INTO EXHIBIT (FK_INVENTORY_ID, FK_PLAN_ID) VALUES (3, 3); -- Twisted Form → Spring VIP
|
|
INSERT INTO EXHIBIT (FK_INVENTORY_ID, FK_PLAN_ID) VALUES (4, 4); -- Blue Symmetry → Summer Basic
|
|
INSERT INTO EXHIBIT (FK_INVENTORY_ID, FK_PLAN_ID) VALUES (5, 5); -- Urban Collage → Summer Plus
|
|
INSERT INTO EXHIBIT (FK_INVENTORY_ID, FK_PLAN_ID) VALUES (6, 6); -- Urban Solitude → Summer Premium
|
|
INSERT INTO EXHIBIT (FK_INVENTORY_ID, FK_PLAN_ID) VALUES (7, 7); -- Earth Vessel → Fall Access
|
|
INSERT INTO EXHIBIT (FK_INVENTORY_ID, FK_PLAN_ID) VALUES (8, 8); -- Quiet Reflection → Fall Full Day
|
|
INSERT INTO EXHIBIT (FK_INVENTORY_ID, FK_PLAN_ID) VALUES (9, 9); -- Neon Dreams → Fall Weekend
|
|
INSERT INTO EXHIBIT (FK_INVENTORY_ID, FK_PLAN_ID) VALUES (10, 10); -- Woven Stories → Annual Pass
|
|
|
|
|
|
INSERT INTO INVOICE (FK_CONTACT_ID, FK_PLAN_ID, InvoiceDate, AmountPaid) VALUES (9, 1, DATE'2025-01-01', 75.00); -- Bob — Spring Preview
|
|
INSERT INTO INVOICE (FK_CONTACT_ID, FK_PLAN_ID, InvoiceDate, AmountPaid) VALUES (10, 2, DATE'2025-01-02', 120.00); -- Carol — Spring Standard
|
|
INSERT INTO INVOICE (FK_CONTACT_ID, FK_PLAN_ID, InvoiceDate, AmountPaid) VALUES (11, 3, DATE'2025-01-03', 250.00); -- David — Spring VIP
|
|
INSERT INTO INVOICE (FK_CONTACT_ID, FK_PLAN_ID, InvoiceDate, AmountPaid) VALUES (12, 4, DATE'2025-01-04', 50.00); -- Emma — Summer Basic
|
|
INSERT INTO INVOICE (FK_CONTACT_ID, FK_PLAN_ID, InvoiceDate, AmountPaid) VALUES (9, 5, DATE'2025-01-05', 100.00); -- Bob — Summer Plus
|
|
INSERT INTO INVOICE (FK_CONTACT_ID, FK_PLAN_ID, InvoiceDate, AmountPaid) VALUES (10, 6, DATE'2025-01-06', 150.00); -- Carol — Summer Premium
|
|
INSERT INTO INVOICE (FK_CONTACT_ID, FK_PLAN_ID, InvoiceDate, AmountPaid) VALUES (11, 7, DATE'2025-01-07', 60.00); -- David — Fall Access
|
|
INSERT INTO INVOICE (FK_CONTACT_ID, FK_PLAN_ID, InvoiceDate, AmountPaid) VALUES (12, 8, DATE'2025-01-08', 110.00); -- Emma — Fall Full Day
|
|
INSERT INTO INVOICE (FK_CONTACT_ID, FK_PLAN_ID, InvoiceDate, AmountPaid) VALUES (9, 9, DATE'2025-01-09', 180.00); -- Bob — Fall Weekend
|
|
INSERT INTO INVOICE (FK_CONTACT_ID, FK_PLAN_ID, InvoiceDate, AmountPaid) VALUES (10, 10, DATE'2025-01-10', 500.00); -- Carol — Annual Pass
|
|
|
|
INSERT INTO ORDER_ITEMS (FK_PROFILE_ID, TRANSACTION_ID, CREATED_AT, QUANTITY, UNIT_PRICE, LINE_TOTAL, FK_INVENTORY_ID)
|
|
VALUES (9, 'TXN-2025-0001', TIMESTAMP'2025-02-01 10:00:00', 2, 1200.00, 1200.00, 1); -- Bob → Crimson Horizon
|
|
INSERT INTO ORDER_ITEMS (FK_PROFILE_ID, TRANSACTION_ID, CREATED_AT, QUANTITY, UNIT_PRICE, LINE_TOTAL, FK_INVENTORY_ID)
|
|
VALUES (11, 'TXN-2025-0002', TIMESTAMP'2025-02-03 11:30:00', 1, 700.00, 700.00, 2); -- David → Misty Valley
|
|
|
|
INSERT INTO TASK_HISTORY (ASSIGNED_TO_PROFILE_ID, CREATED_BY_PROFILE_ID, RELATED_ENTITY_TYPE, RELATED_ENTITY_ID,
|
|
TASK_TYPE, TASK_TITLE, DESCRIPTION, FK_DOCUMENT_ID, STATUS, DUE_DATE)
|
|
VALUES (5, 2, 'order', 2, 'logistics', 'Ship Misty Valley', 'Coordinate pickup from Stephen', 3, 'completed', TIMESTAMP'2025-02-15 17:00:00');
|
|
|
|
INSERT INTO TASK_HISTORY (ASSIGNED_TO_PROFILE_ID, CREATED_BY_PROFILE_ID, RELATED_ENTITY_TYPE, RELATED_ENTITY_ID,
|
|
TASK_TYPE, TASK_TITLE, DESCRIPTION, FK_DOCUMENT_ID, STATUS, DUE_DATE)
|
|
VALUES (4, 2, 'supplier', 7, 'review', 'Review consignment docs', 'Check Henry paperwork', 8, 'completed', TIMESTAMP'2025-03-01 12:00:00');
|
|
|
|
|
|
|
|
COMMIT;
|
|
|