fittersweat
Tables (10)
events
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- city_code — VARCHAR(10) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- event_url — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
interested_events
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- event_id — BIGINT — Foreign key → events.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
order_items
- id — BIGSERIAL — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- product_id — BIGINT — Foreign key → products.id — NOT NULL
- quantity — INT — NOT NULL
- unit_price — DECIMAL(12, 2) — NOT NULL
orders
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- total_amount — DECIMAL(12, 2) — NOT NULL
- payment_key — VARCHAR(255)
- paid_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
post_comments
- id — BIGSERIAL — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
post_product_tags
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- product_id — BIGINT — Foreign key → products.id — NOT NULL
posts
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- event_id — BIGINT — Foreign key → events.id
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- embedding — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
products
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- category_id — VARCHAR(50) — NOT NULL
- price — DECIMAL(12, 2) — NOT NULL
- stock_quantity — INT — NOT NULL
- embedding — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
reviews
- id — BIGSERIAL — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → products.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- rating — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL