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