Edit: Alt photo gallery

(Descriptions) Person, circa 2015, Tattoo on Person's neck, Person in the clothes they were wearing at the time of their disappearance; Shoes similar to the ones person was wearing

Public Info

{contain only verified, public information. Fill in / Delete as needed}

- case_id: A unique identifier (e.g. CASE-001)

- full_name: The individual's name

- date_missing: The official date.

Missing Since (Date)

- location: City, state, or region

Missing From (City, State)

- Demographics: Age, height, identifying features.

Age (30 Years Old)

Height and Weight (5'6 - 5'8, 140-150 Pounds

Classification (Endangered Missing)

Sex (Male/Female/NB)

Race (White/Black/Mix)

- agency_contact: Law enforcement handling.

Narrative

{Instead of jamming your personal writing and findings into the same record, create a separate "Blog" or "Analysis" table.

 You can link it back to the public data using the case_ID.}

- post_id: Unique identifier for your blog entry

- case_id: This links it directly to the public profile above/

- date_written: When you logged your findings/

- content_body: Your analysis, theories,  and connections/

- clue_tags: Metadata keywords you assign to track patterns across different cases.

How to Present It on the Frontend

When a user (or you, in your private view) clicks on a profile, thje user interface can pull from both tables simultaneously but display them in a clear hierarchy:

[Photo] John Doe

Missing Since 10/12/2018 |

Location: Seattle, WA

Official Status: Cold Case

PUBLIC DATA & TIMELINE

* 10:00 AM - Last seen at transit station.

*11:30 AM - Vehicle found abandoned.

MY RESEARCH & LOGGED FINDINGS (Secondary)

"Looking into the geographical overlap between this case and the 2019 incident..."

Details of Disappearance

Doe was last seen in (City, State) on (Month, Day, Year). She left home between 3:00 and 4:00 p.m., and got into a car with three other people, en route to (City, State). She sent her boyfriend a text at 11:00 p.m., indicating she was on her way back from (City, State), but she never arrived and has never been heard from again.

It's uncharacteristic of Doe to leave without warning, and she left her purse and other belongings behind, except for her cellular phone. She also left behind her three children, and police are concerned for her safety. Her disappearance remains unsolved.

Distinguishing Characteristics

Clothing/Jewelry Description

Source Information