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