ssok-gemini
Tables (6)
artists
- artist_id — SERIAL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- profile_img — TEXT
- bio — TEXT
- is_verified — BOOLEAN
- royalty_rate — DECIMAL(5, 2)
funding_projects
- project_id — SERIAL
- creator_id — INT — Foreign key → users.user_id — NOT NULL
- artist_id — INT — Foreign key → artists.artist_id — NOT NULL
- vendor_id — INT — Foreign key → vendors.vendor_id
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- ai_image_url — TEXT — NOT NULL
- status — VARCHAR(30)
- max_unit_price — INT — NOT NULL
- target_date — TIMESTAMP
- current_count — INT
- created_at — TIMESTAMP
orders
- order_id — SERIAL
- project_id — INT — Foreign key → funding_projects.project_id — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- total_paid — INT — NOT NULL
- refund_amount — INT
- status — VARCHAR(20)
- tracking_number — VARCHAR(100)
- address — TEXT — NOT NULL
- ordered_at — TIMESTAMP
users
- user_id — SERIAL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- role — VARCHAR(20)
- created_at — TIMESTAMP
vendor_products
- v_prod_id — SERIAL
- vendor_id — INT — Foreign key → vendors.vendor_id — NOT NULL
- category_name — VARCHAR(50)
- min_quantity — INT — NOT NULL
- max_quantity — INT — NOT NULL
- price_per_unit — INT — NOT NULL
vendors
- vendor_id — SERIAL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- company_name — VARCHAR(100)
- shipping_fee — INT
- weekly_min_capacity — INT
- weekly_max_capacity — INT