rlpDB
Tables (6)
accidentHistory
- history_id — Primary key — NOT NULL
- wv_id — Foreign key → accidentWitness.wv_id — NOT NULL
- wu_id — Foreign key → accidentWitness.wu_id — NOT NULL
- acc_no — Foreign key → accidentWitness.acc_no — NOT NULL
- au_id — Foreign key → accidentWitness.au_id — NOT NULL
- status
accidentReport
- acc_no — Primary key — NOT NULL
- au_id — Foreign key → user.u_id — NOT NULL
- acc_vid
- acc_url
- acc_place
- acc_title
- acc_description
- acc_time
accidentWitness
- wv_id — Foreign key → witness.wv_id — NOT NULL
- wu_id — Foreign key → witness.wu_id — NOT NULL
- acc_no — Foreign key → accidentReport.acc_no — NOT NULL
- au_id — Foreign key → accidentReport.au_id — NOT NULL
request
- request_no (request_n) — Primary key — NOT NULL
- acc_no — Foreign key → accidentReport.acc_no — NOT NULL
- au_id — Foreign key → accidentReport.au_id — NOT NULL
- req_time
- accepted
user
- u_id — Primary key — NOT NULL
- u_pwd
- u_phone
- u_alias
- u_email
witness
- wv_id — Primary key — NOT NULL
- wu_id — Foreign key → user.u_id — NOT NULL
- wv_url
- w_place
- upload_uid
- w_time