module_project
Tables (8)
listing_photos
- id — VARCHAR(48) — Primary key — NOT NULL
- listing_id — VARCHAR(48) — Foreign key → listings.id — NOT NULL
- url — VARCHAR(2000) — NOT NULL
- sort_order — INTEGER — NOT NULL
- created_at — VARCHAR(40) — NOT NULL
listings
- id — VARCHAR(48) — Primary key — NOT NULL
- seller_id — VARCHAR(80) — NOT NULL
- kind — VARCHAR(20) — NOT NULL
- category — VARCHAR(24) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- price — INTEGER — NOT NULL
- emoji — VARCHAR(8)
- location — VARCHAR(500)
- stock — INTEGER
- max_guests — INTEGER
- created_at — VARCHAR(40) — NOT NULL
- cover_image_url — VARCHAR(2000)
- guide_json — TEXT
- variants_json — TEXT
- details_json — TEXT
ocr_logs
- id — VARCHAR(48) — Primary key — NOT NULL
- user_id — VARCHAR(48) — Foreign key → users.id
- seller_id — VARCHAR(80)
- image_paths — TEXT
- ocr_raw_text — TEXT
- parsed_json — TEXT
- confidence — REAL
- created_at — VARCHAR(40) — NOT NULL
orders
- id — VARCHAR(48) — Primary key — NOT NULL
- created_at — VARCHAR(40) — NOT NULL
- buyer_id — VARCHAR(48) — Foreign key → users.id
- buyer_name — VARCHAR(100) — NOT NULL
- buyer_phone — VARCHAR(30) — NOT NULL
- items_json — TEXT — NOT NULL
- total — INTEGER — NOT NULL
- payment_status — VARCHAR(20) — NOT NULL
- fulfillment_status — VARCHAR(24) — NOT NULL
- stay_start — VARCHAR(10)
- stay_end — VARCHAR(10)
- payment_json — TEXT
review_summaries
- listing_id — VARCHAR(48) — Foreign key → listings.id — NOT NULL
- summary — TEXT — NOT NULL
- hash — VARCHAR(64) — NOT NULL
- updated_at — VARCHAR(40) — NOT NULL
reviews
- id — VARCHAR(48) — Primary key — NOT NULL
- listing_id — VARCHAR(48) — Foreign key → listings.id — NOT NULL
- order_id — VARCHAR(48) — Foreign key → orders.id
- user_id — VARCHAR(48) — Foreign key → users.id — NOT NULL
- user_name — VARCHAR(100) — NOT NULL
- rating — INTEGER — NOT NULL
- body — TEXT
- created_at — VARCHAR(40) — NOT NULL
users
- id — VARCHAR(48) — Primary key — NOT NULL
- email — VARCHAR(200) — NOT NULL
- password_hash — VARCHAR(256) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- display_name — VARCHAR(100) — NOT NULL
- seller_sector — VARCHAR(24)
- seller_id — VARCHAR(80)
- created_at — VARCHAR(40) — NOT NULL
voice_logs
- id — VARCHAR(48) — Primary key — NOT NULL
- user_id — VARCHAR(48) — Foreign key → users.id
- seller_id — VARCHAR(80)
- source — VARCHAR(20) — NOT NULL
- audio_path — VARCHAR(500)
- raw_text — TEXT
- corrected_text — TEXT
- created_at — VARCHAR(40) — NOT NULL