tfinder

Tables (7)

Copy Of Untitled (trashcan_recommend)

  • id (trashcan_id) — SERIAL — Foreign key → trashcan_info.id — NOT NULL
  • Key (user_id) — varchar(100) — Foreign key → Untitled.Key — NOT NULL
  • Field (description) — TEXT

Untitled (trashcan_detail)

  • id (trashcan_id) — SERIAL — Foreign key → trashcan_info.id — NOT NULL
  • Field2 (cateroty) — TEXT
  • Field (recommend_count) — INT
  • Field (views) — INT
  • Field (report_count) — INT

Untitled (trashcan_images)

  • id (trashcan_id) — SERIAL — Foreign key → trashcan_info.id — NOT NULL
  • Field (image_url) — TEXT — NOT NULL

Untitled (trashcan_description)

  • id (trashcan_id) — SERIAL — Foreign key → trashcan_info.id — NOT NULL
  • Field (description) — TEXT — NOT NULL

Untitled (user_info)

  • Key (user_id) — varchar(100) — Primary key — NOT NULL
  • Field (created_at) — TIMESTAMP WITH TIME ZONE
  • Field (is_admin) — BOOLEAN

Untitled (trashcan_reported)

  • id (trashcan_id) — SERIAL — Foreign key → trashcan_info.id — NOT NULL
  • Key (user_id) — varchar(100) — Foreign key → Untitled.Key — NOT NULL
  • Field (description) — TEXT

trashcan_info

  • id (trashcan_id) — SERIAL — Primary key — NOT NULL
  • Field (location) — POINT — NOT NULL
  • Field (address) — TEXT
  • Field (address_detail) — TEXT
  • Key (user_id) — varchar(100) — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — TIMESTAMP WITH TIME ZONE
  • Field (status) — varchar(10)
  • Field