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