create table public.test_sales_data
(
    id             serial
        primary key,
    order_id       varchar(50)    not null,
    order_date     date           not null,
    customer_id    varchar(50)    not null,
    customer_name  varchar(100),
    product_id     varchar(50)    not null,
    product_name   varchar(200),
    category       varchar(100),
    quantity       integer        not null,
    unit_price     numeric(10, 2) not null,
    total_amount   numeric(12, 2) not null,
    discount_rate  numeric(5, 2) default 0,
    payment_method varchar(50),
    region         varchar(100),
    city           varchar(100),
    status         varchar(50)   default 'completed'::character varying,
    created_at     timestamp     default CURRENT_TIMESTAMP
);

comment on table public.test_sales_data is 'Sales data table - test data';

alter table public.test_sales_data
    owner to postgres;