4
Tables (13)
author
- author_id — SERIAL — Primary key
- name — VARCHAR(255) — NOT NULL
basket_item
- basket_item_id — SERIAL
- basket_id — INT
- product_id — INT
- format_id — INT
- offer_price — NUMERIC(12,2) — NOT NULL
- quantity — INT — NOT NULL
- added_at — TIMESTAMP
customer
- customer_id — SERIAL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(255)
- address — TEXT
- phone — VARCHAR(50)
format
- format_id — SERIAL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
offer
- product_id — INT
- format_id — INT
- price — NUMERIC(12,2) — NOT NULL
- stock — INT
- additional_info — JSONB
order
- order_id — SERIAL
- customer_id — INT
- order_date — TIMESTAMP
- total_amount — NUMERIC(14,2)
- status — VARCHAR(50)
order_item
- order_item_id — SERIAL
- order_id — INT
- product_id — INT
- format_id — INT
- unit_price — NUMERIC(12,2) — NOT NULL
- quantity — INT — NOT NULL
product
- product_id — SERIAL — Primary key
- title — VARCHAR(512) — NOT NULL
- isbn — VARCHAR(50)
- year — INT
- description — TEXT
- publisher_id (publisher_id2) — SERIAL — Foreign key → publisher.publisher_id
publisher
- publisher_id — SERIAL — Primary key
- name — VARCHAR(255) — NOT NULL
shopping_basket
- basket_id — SERIAL
- customer_id — INT
- created_at — TIMESTAMP
- status — VARCHAR(50)
stock
- stock_id — SERIAL
- warehouse_id — INT
- product_id — INT
- format_id — INT
- quantity — INT — NOT NULL
warehouse
- warehouse_id — SERIAL
- code — VARCHAR(50)
- address — TEXT
- phone — VARCHAR(50)
written_by
- product_id — INT
- author_id — INT