PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "Documents" (
"Document_ID" INT UNIQUE,
"Template_ID" INT,
"Document_Name" VARCHAR(255),
"Document_Description" VARCHAR(255),
PRIMARY KEY ("Document_ID"),
FOREIGN KEY ("Template_ID") REFERENCES "Templates"("Template_ID")
);

CREATE TABLE "Paragraphs" (
"Paragraph_ID" INT,
"Paragraph_Text" VARCHAR(255),
PRIMARY KEY ("Paragraph_ID")
);

CREATE TABLE "Ref_Template_Types" (
"Template_Type_Code" CHAR(15),
"Template_Type_Description" VARCHAR(255),
PRIMARY KEY ("Template_Type_Code")
);

CREATE TABLE "Templates" (
"Template_ID" INT,
"Template_Details" VARCHAR(255),
PRIMARY KEY ("Template_ID")
);





INSERT INTO "Ref_Template_Types" VALUES ("REP", "Report Template");
INSERT INTO "Ref_Template_Types" VALUES ("INV", "Invoice Template");
INSERT INTO "Ref_Template_Types" VALUES ("MEM", "Memorandum Template");
INSERT INTO "Ref_Template_Types" VALUES ("PRO", "Proposal Template");
INSERT INTO "Ref_Template_Types" VALUES ("AGR", "Agreement Template");
INSERT INTO "Templates" VALUES ("101", "Standard Report Template Details");
INSERT INTO "Templates" VALUES ("102", "Detailed Invoice Template Details");
INSERT INTO "Templates" VALUES ("103", "Internal Memo Template Details");
INSERT INTO "Templates" VALUES ("104", "Project Proposal Template Details");
INSERT INTO "Templates" VALUES ("105", "Service Agreement Template Details");
INSERT INTO "Templates" VALUES ("106", "Simple Report Template Details");
INSERT INTO "Templates" VALUES ("107", "Complex Invoice Template Details");
INSERT INTO "Documents" VALUES ("1", "101", "Monthly Sales Report", "This document provides a monthly overview of sales performance, with a focus on growth.");
INSERT INTO "Documents" VALUES ("2", "102", "Client Invoice Q1", "Invoice for services rendered in Q1. Please review carefully.");
INSERT INTO "Documents" VALUES ("3", "103", "Meeting Minutes 2023-10-26", "Minutes from the weekly team meeting. We will follow up on action items.");
INSERT INTO "Documents" VALUES ("4", "104", "New Project Proposal", "Proposal for a new software development project. We want to win this one.");
INSERT INTO "Documents" VALUES ("5", "105", "Consulting Agreement", "Agreement outlining the terms of the consulting engagement. This is a weighty document.");
INSERT INTO "Documents" VALUES ("6", "101", "Annual Financial Review", "A comprehensive review of the companys annual financial performance. This document is worthwhile.");
INSERT INTO "Documents" VALUES ("7", "102", "Supplier Payment Request", "Request for payment to our new hardware supplier. We need to process this swiftly.");
INSERT INTO "Documents" VALUES ("8", "103", "Company Policy Update", "Update to the companys remote work policy. Please be aware of new guidelines.");
INSERT INTO "Documents" VALUES ("9", "104", "Marketing Campaign Plan", "Plan for the upcoming winter marketing campaign. We aim for widespread awareness.");
INSERT INTO "Documents" VALUES ("10", "105", "Partnership Agreement Draft", "Draft of a new partnership agreement. This document requires careful review and will be reworked.");
INSERT INTO "Documents" VALUES ("11", "106", "Weekly Progress Report", "A brief weekly update on project progress. We are working towards our goals.");
INSERT INTO "Documents" VALUES ("12", "107", "Warranty Claim Form", "Form for submitting a product warranty claim. Please fill out all required fields.");
INSERT INTO "Documents" VALUES ("13", "101", "Website Content Review", "Review of current website content. We want to improve user experience.");
INSERT INTO "Documents" VALUES ("14", "103", "Internal Memo on Workflow", "Memo discussing new workflow procedures. This will streamline our work.");
INSERT INTO "Documents" VALUES ("15", "104", "Software Development Proposal", "Proposal for a new software development project. We will win this one.");
INSERT INTO "Documents" VALUES ("16", "105", "Client Service Agreement", "Agreement for ongoing client services. This document is well-written.");
INSERT INTO "Documents" VALUES ("17", "101", "Quarterly Business Review", "Overview of business performance for the quarter. We are growing well.");
INSERT INTO "Documents" VALUES ("18", "102", "Outstanding Invoice Reminder", "Reminder for an overdue invoice. We await your payment.");
INSERT INTO "Documents" VALUES ("19", "103", "New Employee Welcome Packet", "Welcome packet for new employees. We wish them well.");
INSERT INTO "Documents" VALUES ("20", "104", "Investment Proposal", "Proposal for potential investors. We want to wow them.");
INSERT INTO "Documents" VALUES ("21", "105", "Non-Disclosure Agreement", "Standard NDA document. This is a worldwide agreement.");
INSERT INTO "Documents" VALUES ("22", "101", "Project Closure Report", "Final report for a completed project. This marks the winding down.");
INSERT INTO "Documents" VALUES ("23", "102", "Refund Request Form", "Form for requesting a refund. We will process this within two weeks.");
INSERT INTO "Documents" VALUES ("24", "103", "Internal Communication Policy", "Policy on internal communications. We want to improve how we work.");
INSERT INTO "Documents" VALUES ("25", "104", "Grant Application", "Application for a research grant. We hope to win this award.");
INSERT INTO "Documents" VALUES ("26", "105", "Vendor Contract Renewal", "Renewal of a vendor contract. This is a worthwhile renewal.");
INSERT INTO "Documents" VALUES ("27", "101", "Weekly Sales Summary", "A quick summary of weekly sales figures. We are doing well.");
INSERT INTO "Documents" VALUES ("28", "102", "Payment Confirmation", "Confirmation of a recent payment. We appreciate your business.");
INSERT INTO "Documents" VALUES ("29", "103", "Employee Handbook Update", "Update to the employee handbook. We want to ensure everyone is aware.");
INSERT INTO "Documents" VALUES ("30", "104", "Event Sponsorship Proposal", "Proposal for sponsoring an upcoming event. We want to be involved.");
INSERT INTO "Documents" VALUES ("31", "105", "License Agreement", "Software license agreement. This document is worldwide.");
INSERT INTO "Documents" VALUES ("32", "101", "Market Research Report", "Report on recent market research findings. We want to know more.");
INSERT INTO "Documents" VALUES ("33", "102", "Purchase Order", "Official purchase order for new equipment. We will await delivery.");
INSERT INTO "Documents" VALUES ("34", "103", "Travel Policy Guidelines", "Guidelines for company travel. We want to ensure smooth trips.");
INSERT INTO "Documents" VALUES ("35", "104", "Partnership Pitch Deck", "Presentation for potential partners. We want to win them over.");
INSERT INTO "Documents" VALUES ("36", "105", "Service Level Agreement", "SLA for IT services. This document is well-defined.");
INSERT INTO "Documents" VALUES ("37", "101", "Customer Feedback Analysis", "Analysis of customer feedback. We want to improve our services.");
INSERT INTO "Documents" VALUES ("38", "102", "Credit Note", "Credit note issued to a client. We want to resolve this quickly.");
INSERT INTO "Documents" VALUES ("39", "103", "Onboarding Checklist", "Checklist for new employee onboarding. We want a smooth process.");
INSERT INTO "Documents" VALUES ("40", "104", "Funding Request", "Request for additional project funding. We want to grow.");
INSERT INTO "Documents" VALUES ("41", "105", "Memorandum of Understanding", "MOU between two parties. This is a weighty agreement.");
INSERT INTO "Documents" VALUES ("42", "101", "Competitor Analysis", "Analysis of competitor strategies. We want to stay ahead.");
INSERT INTO "Documents" VALUES ("43", "102", "Proforma Invoice", "Proforma invoice for future services. We will await confirmation.");
INSERT INTO "Documents" VALUES ("44", "103", "Security Policy", "Company security policy. We want to ensure data safety.");
INSERT INTO "Documents" VALUES ("45", "104", "Business Plan", "Comprehensive business plan. We want to achieve our goals.");
INSERT INTO "Documents" VALUES ("46", "105", "Joint Venture Agreement", "Agreement for a joint venture. This is a worldwide venture.");
INSERT INTO "Documents" VALUES ("47", "101", "Product Launch Report", "Report on the recent product launch. We want to evaluate its success.");
INSERT INTO "Documents" VALUES ("48", "102", "Receipt", "Receipt for a recent transaction. We want to keep accurate records.");
INSERT INTO "Documents" VALUES ("49", "103", "Emergency Procedures", "Emergency procedures document. We want everyone to be aware.");
INSERT INTO "Documents" VALUES ("50", "104", "Research Grant Proposal", "Proposal for a research grant. We want to win this award.");
INSERT INTO "Documents" VALUES ("51", "105", "Distribution Agreement", "Agreement for product distribution. This is a worthwhile agreement.");
INSERT INTO "Documents" VALUES ("52", "101", "Website Analytics Report", "Report on website traffic and user behavior. We want to improve our web presence.");
INSERT INTO "Documents" VALUES ("53", "102", "Subscription Renewal Notice", "Notice for subscription renewal. We hope you will continue with us.");
INSERT INTO "Documents" VALUES ("54", "103", "IT Policy Manual", "Manual for IT policies and procedures. We want to ensure compliance.");
INSERT INTO "Documents" VALUES ("55", "104", "Startup Funding Pitch", "Pitch deck for startup funding. We want to wow investors.");
INSERT INTO "Documents" VALUES ("56", "105", "Franchise Agreement", "Agreement for a new franchise. This document is well-structured.");
INSERT INTO "Documents" VALUES ("57", "101", "Social Media Performance", "Report on social media campaign performance. We want to grow our reach.");
INSERT INTO "Documents" VALUES ("58", "102", "Payment Schedule", "Schedule for upcoming payments. We want to ensure timely transactions.");
INSERT INTO "Documents" VALUES ("59", "103", "Employee Performance Review", "Template for employee performance reviews. We want to provide constructive feedback.");
INSERT INTO "Documents" VALUES ("60", "104", "Event Planning Document", "Document outlining the plan for an upcoming event. We want it to be wonderful.");
INSERT INTO "Documents" VALUES ("61", "105", "Lease Agreement", "Lease agreement for office space. This is a weighty document.");
INSERT INTO "Documents" VALUES ("62", "101", "Customer Satisfaction Survey", "Results from the customer satisfaction survey. We want to improve.");
INSERT INTO "Documents" VALUES ("63", "102", "Bill of Lading", "Bill of lading for shipped goods. We want to track our shipments.");
INSERT INTO "Documents" VALUES ("64", "103", "Work From Home Policy", "Policy for working from home. We want to ensure flexibility.");
INSERT INTO "Documents" VALUES ("65", "104", "Product Development Roadmap", "Roadmap for future product development. We want to innovate.");
INSERT INTO "Documents" VALUES ("66", "105", "Confidentiality Agreement", "Standard confidentiality agreement. This is a worldwide agreement.");
INSERT INTO "Documents" VALUES ("67", "101", "Training Program Evaluation", "Evaluation of a recent training program. We want to assess its effectiveness.");
INSERT INTO "Documents" VALUES ("68", "102", "Credit Application", "Application for credit. We want to assess financial standing.");
INSERT INTO "Documents" VALUES ("69", "103", "Data Privacy Policy", "Company data privacy policy. We want to ensure compliance.");
INSERT INTO "Documents" VALUES ("70", "104", "Market Entry Strategy", "Strategy for entering a new market. We want to expand our reach.");
INSERT INTO "Documents" VALUES ("71", "105", "Employment Contract", "Standard employment contract. This is a well-defined document.");
INSERT INTO "Documents" VALUES ("72", "101", "Competitor Pricing Analysis", "Analysis of competitor pricing strategies. We want to remain competitive.");
INSERT INTO "Documents" VALUES ("73", "102", "Invoice Adjustment Request", "Request for an invoice adjustment. We want to resolve discrepancies.");
INSERT INTO "Documents" VALUES ("74", "103", "Employee Grievance Procedure", "Procedure for employee grievances. We want to ensure fair treatment.");
INSERT INTO "Documents" VALUES ("75", "104", "Business Expansion Plan", "Plan for business expansion. We want to grow our operations.");
INSERT INTO "Documents" VALUES ("76", "105", "Partnership Dissolution Agreement", "Agreement for dissolving a partnership. This is a weighty decision.");
INSERT INTO "Documents" VALUES ("77", "101", "Website Redesign Proposal", "Proposal for a website redesign. We want to improve user experience.");
INSERT INTO "Documents" VALUES ("78", "102", "Payment Reminder", "Reminder for an upcoming payment. We want to ensure timely transactions.");
INSERT INTO "Documents" VALUES ("79", "103", "Code of Conduct", "Company code of conduct. We want to ensure ethical behavior.");
INSERT INTO "Documents" VALUES ("80", "104", "Product Feature Request", "Request for new product features. We want to innovate.");
INSERT INTO "Documents" VALUES ("81", "105", "Intellectual Property Agreement", "Agreement for intellectual property rights. This is a worldwide agreement.");
INSERT INTO "Documents" VALUES ("82", "101", "Annual Report Draft", "Draft of the annual company report. We want to present our achievements.");
INSERT INTO "Documents" VALUES ("83", "102", "Refund Policy", "Company refund policy. We want to ensure customer satisfaction.");
INSERT INTO "Documents" VALUES ("84", "103", "Disciplinary Procedure", "Company disciplinary procedure. We want to ensure fairness.");
INSERT INTO "Documents" VALUES ("85", "104", "Marketing Budget Proposal", "Proposal for the marketing budget. We want to allocate resources wisely.");
INSERT INTO "Documents" VALUES ("86", "105", "Shareholder Agreement", "Agreement among shareholders. This is a well-structured document.");
INSERT INTO "Documents" VALUES ("87", "101", "Customer Onboarding Guide", "Guide for onboarding new customers. We want a smooth process.");
INSERT INTO "Documents" VALUES ("88", "102", "Service Quote", "Quote for services. We want to provide clear pricing.");
INSERT INTO "Documents" VALUES ("89", "103", "Remote Work Guidelines", "Guidelines for remote work. We want to ensure productivity.");
INSERT INTO "Documents" VALUES ("90", "104", "Sales Strategy Document", "Document outlining the sales strategy. We want to increase revenue.");
INSERT INTO "Documents" VALUES ("91", "105", "Consulting Services Agreement", "Agreement for consulting services. This is a worthwhile agreement.");
INSERT INTO "Documents" VALUES ("92", "101", "Employee Satisfaction Survey", "Results from the employee satisfaction survey. We want to improve workplace morale.");
INSERT INTO "Documents" VALUES ("93", "102", "Payment Plan Agreement", "Agreement for a payment plan. We want to offer flexibility.");
INSERT INTO "Documents" VALUES ("94", "103", "Crisis Communication Plan", "Plan for crisis communication. We want to be prepared.");
INSERT INTO "Documents" VALUES ("95", "104", "Product Roadmap", "Roadmap for product development. We want to innovate continuously.");
INSERT INTO "Documents" VALUES ("96", "105", "Master Service Agreement", "Master service agreement. This is a weighty document.");
INSERT INTO "Documents" VALUES ("97", "101", "Training Needs Analysis", "Analysis of training needs. We want to develop our employees.");
INSERT INTO "Documents" VALUES ("98", "102", "Invoice Dispute Resolution", "Procedure for invoice dispute resolution. We want to resolve issues quickly.");
INSERT INTO "Documents" VALUES ("99", "103", "Health and Safety Policy", "Company health and safety policy. We want to ensure a safe workplace.");
INSERT INTO "Documents" VALUES ("100", "104", "Investment Opportunity Brief", "Brief on an investment opportunity. We want to attract investors.");
INSERT INTO "Paragraphs" VALUES ("1", "This is the first paragraph of the document.");
INSERT INTO "Paragraphs" VALUES ("2", "The second paragraph contains important details.");
INSERT INTO "Paragraphs" VALUES ("3", "A third paragraph for additional information.");
INSERT INTO "Paragraphs" VALUES ("4", "This paragraph discusses the new workflow.");
INSERT INTO "Paragraphs" VALUES ("5", "Final paragraph with concluding remarks.");