ExcelTL - Documentation

CREATE TABLE account (
  account_id SERIAL PRIMARY KEY,
  account_name VARCHAR(255),
  industry VARCHAR(255),
  website VARCHAR(255),
  annual_revenue BIGINT,
  phone VARCHAR(20),
  country VARCHAR(100),
  city VARCHAR(100),
  state VARCHAR(100),
  contact_email VARCHAR(255),
  created_date DATE,
  modified_date DATE
);

INSERT INTO account
(account_id, account_name, industry, website, annual_revenue, phone, country, city, state, contact_email, created_date, modified_date)
VALUES
('1', 'Acme Corp', 'Technology', 'www.acmecorp.com', 50000000.00, '123-456-7890', 'USA', 'New York', 'NY', 'info@acmecorp.com', '2020-01-15', '2022-05-10'),
('2', 'Global Solutions', 'Finance', 'www.globalsolutions.com', 120000000.00, '987-654-3210', 'UK', 'London', 'England', 'contact@globalsolutions.com', '2018-06-25', '2022-04-14'),
('3', 'Tech Innovations', 'Technology', 'www.techinnovations.com', 75000000.00, '555-123-4567', 'USA', 'San Francisco', 'CA', 'support@techinnovations.com', '2019-03-02', '2022-07-01'),
('4', 'Green Earth Energy', 'Energy', 'www.greenearth.com', 30000000.00, '321-987-6543', 'Canada', 'Toronto', 'ON', 'info@greenearth.com', '2021-05-10', '2022-06-30'),
('5', 'Elite Marketing', 'Advertising', 'www.elitemarketing.com', 15000000.00, '234-567-8901', 'Australia', 'Sydney', 'NSW', 'contact@elitemarketing.com', '2020-11-21', '2022-08-25'),
('6', 'Creative Studios', 'Entertainment', 'www.creativestudios.com', 20000000.00, '543-210-9876', 'USA', 'Los Angeles', 'CA', 'info@creativestudios.com', '2021-02-10', '2022-09-15'),
('7', 'HealthTech Solutions', 'Healthcare', 'www.healthtechsolutions.com', 95000000.00, '876-543-2109', 'USA', 'Boston', 'MA', 'info@healthtechsolutions.com', '2020-04-05', '2022-10-20'),
('8', 'Future Enterprises', 'Manufacturing', 'www.futureenterprises.com', 100000000.00, '212-345-6789', 'Germany', 'Berlin', 'BE', 'contact@futureenterprises.com', '2017-08-18', '2022-09-10'),
('9', 'Visionary Products', 'Retail', 'www.visionaryproducts.com', 40000000.00, '908-123-4567', 'UK', 'Manchester', 'England', 'support@visionaryproducts.com', '2019-01-22', '2022-08-12'),
('10', 'Cloud Services', 'Technology', 'www.cloudservices.com', 60000000.00, '654-321-0987', 'Canada', 'Vancouver', 'BC', 'info@cloudservices.com', '2021-03-28', '2022-11-05'),
('11', 'NextGen Robotics', 'Technology', 'www.nextgenrobotics.com', 110000000.00, '432-567-8901', 'USA', 'Detroit', 'MI', 'contact@nextgenrobotics.com', '2018-09-15', '2022-08-30'),
('12', 'Eco Buildings', 'Real Estate', 'www.ecobuildings.com', 25000000.00, '987-321-6540', 'USA', 'Chicago', 'IL', 'info@ecobuildings.com', '2020-06-18', '2022-10-22'),
('13', 'Smart Foods', 'F&B', 'www.smartfoods.com', 45000000.00, '231-876-5432', 'Australia', 'Melbourne', 'VIC', 'contact@smartfoods.com', '2021-02-01', '2022-05-15'),
('14', 'Solar Innovations', 'Energy', 'www.solarinnovations.com', 35000000.00, '345-678-9012', 'USA', 'Denver', 'CO', 'info@solarinnovations.com', '2019-12-10', '2022-04-10'),
('15', 'TechWorks', 'Technology', 'www.techworks.com', 90000000.00, '765-432-1098', 'Canada', 'Ottawa', 'ON', 'contact@techworks.com', '2019-05-30', '2022-06-14'),
('16', 'World Travels', 'Tourism', 'www.worldtravels.com', 50000000.00, '234-567-8902', 'USA', 'Miami', 'FL', 'info@worldtravels.com', '2020-08-08', '2022-07-20'),
('17', 'MobileTech', 'Technology', 'www.mobiletech.com', 130000000.00, '876-543-2108', 'Germany', 'Frankfurt', 'HE', 'support@mobiletech.com', '2017-03-15', '2022-06-05'),
('18', 'Digital Designs', 'Advertising', 'www.digitaldesigns.com', 20000000.00, '543-678-9012', 'UK', 'Manchester', 'England', 'contact@digitaldesigns.com', '2021-01-02', '2022-09-18'),
('19', 'Innovative Solutions', 'Consulting', 'www.innovativesolutions.com', 75000000.00, '345-678-9013', 'Canada', 'Calgary', 'AB', 'info@innovativesolutions.com', '2018-07-13', '2022-08-20'),
('20', 'SafeTech', 'Security', 'www.safetech.com', 80000000.00, '654-321-0988', 'USA', 'Seattle', 'WA', 'contact@safetech.com', '2020-04-12', '2022-10-10');

CREATE TABLE employee (
  unique_id varchar(50) NOT NULL,
  company_name varchar(255) NOT NULL,
  sector varchar(100) NULL,
  homepage varchar(255) NULL,
  revenue numeric(15, 2) NULL,
  contact_phone varchar(50) NULL,
  location_country varchar(100) NULL,
  location_city varchar(100) NULL,
  location_state varchar(50) NULL,
  email_address varchar(255) NULL,
  registration_date date NULL,
  last_updated_date date NULL,
  CONSTRAINT employee_pkey PRIMARY KEY (unique_id)
);