production_time_days
integer
quantity_available
integer
quantity_reserved
integer
Documentation for project Instagram Thrift Creator Store
Project
Name
Instagram Thrift Creator Store
Report
Generated
4/10/2026 | 1:36:15 PM
tables
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
full_name
varchar
phone
varchar
email
varchar
instagram_handle
varchar
whatsapp_number
varchar
address
varchar
created_at
timestamp
Keys
CUSTOMER_pkey
Column in CUSTOMER_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
title
varchar
description
text
product_type
varchar
price
float8
category
varchar
condition
varchar
size
varchar
color
varchar
image_url
varchar
is_active
bool
created_at
timestamp
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
customer_id
uuid
total_amount
float8
status
notes
text
ordered_at
timestamp
updated_at
timestamp
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
product_id
uuid
is_unique
bool
source_description
text
brand
varchar
age_estimate
varchar
Keys
THRIFT_DETAIL_pkey
Column in THRIFT_DETAIL_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
product_id
uuid
batch_size
integer
materials_used
text
made_by
varchar
production_time_days
integer
Keys
HANDMADE_DETAIL_pkey
Column in HANDMADE_DETAIL_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
order_id
uuid
product_id
uuid
quantity
integer
unit_price
float8
subtotal
float8
Keys
ORDER_ITEM_pkey
Column in ORDER_ITEM_pkey
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
order_id
uuid
amount_paid
float8
method
varchar
status
varchar
transaction_ref
varchar
paid_at
timestamp
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
product_id
uuid
quantity_available
integer
quantity_reserved
integer
last_updated
timestamp
Keys
INVENTORY_pkey1
Column in INVENTORY_pkey1
id
Columns
Name
Data type
Param
Key
Not Null
id
uuid
Yes
Yes
order_id
uuid
carrier
tracking_number
varchar
shipping_address
text
status
shipped_at
timestamp
delivered_at
timestamp
Keys
SHIPMENT_pkey
Column in SHIPMENT_pkey
id
relationships
Name
ORDER_customer_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in CUSTOMER
Column in ORDER
CUSTOMER_pkey
id
customer_id
Name
PAYMENT_order_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in ORDER
Column in PAYMENT
ORDER_pkey
id
order_id
Name
INVENTORY_product_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in PRODUCT
Column in INVENTORY
PRODUCT_pkey
id
product_id
Name
ORDER_ITEM_order_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in ORDER
Column in ORDER_ITEM
ORDER_pkey
id
order_id
Name
ORDER_ITEM_product_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in PRODUCT
Column in ORDER_ITEM
PRODUCT_pkey
id
product_id
Name
HANDMADE_DETAIL_product_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in PRODUCT
Column in HANDMADE_DETAIL
PRODUCT_pkey
id
product_id
Name
SHIPMENT_order_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in ORDER
Column in SHIPMENT
ORDER_pkey
id
order_id
Name
THRIFT_DETAIL_product_id_fkey
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in PRODUCT
Column in THRIFT_DETAIL
PRODUCT_pkey
id
product_id
