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