Missing

Tables (5)

Assingnment (사건 담당)

  • Missing_id (Key) — NUMBER(10) — Foreign key → MissingPerson.Missing_id — NOT NULL
  • Police__id (Key2) — NUMBER(10) — Foreign key → Police.Police__id — NOT NULL
  • Assigned_date (assigned_date) — VARCHAR2(10)

ContactPerson (실종자 가족)

  • Contact_id (contact_id) — NUMBER(10) — Primary key — NOT NULL
  • Name (name) — VARCHAR2(10)
  • Relation (relation) — VARCHAR2(10)
  • Phone (phone) — VARCHAR2(20)
  • Missing_id (Key) — NUMBER(10) — Foreign key → MissingPerson.Missing_id — NOT NULL

MissingPerson (실종자)

  • Missing_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • Name (name) — VARCHAR2(10)
  • Age (age) — NUMBER(5)
  • Gender (gender) — VARCHAR2(5)
  • Missing_date (missing_date) — VARCHAR2(20)
  • Location (location) — VARCHAR2(20)
  • Description (description) — VARCHAR2(20)
  • Status (status) — VARCHAR2(10)

Police (경찰)

  • Police__id (Key) — NUMBER(10) — Primary key — NOT NULL
  • Name (name) — VARCHAR2(10)
  • Station (station) — VARCHAR2(10)
  • Phone (phone) — VARCHAR2(20)

Report (제보)

  • Report_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • Reporter_name (reporter_name) — VARCHAR2(10)
  • Contact (contact) — VARCHAR2(20)
  • Report_content (report_content) — VARCHAR2(30)
  • Report_date (report_date) — VARCHAR2(10)
  • Missing_id (Key2) — NUMBER(10) — Foreign key → MissingPerson.Missing_id — NOT NULL