dsi

Tables (7)

accVid

  • a_id — Foreign key → accident.a_id — NOT NULL
  • a_url

accident

  • a_id — Primary key — NOT NULL
  • a_time — varchar2
  • u_id — varchar2 — Foreign key → user.u_id — NOT NULL
  • a_place — varchar2

help

  • h_id — Primary key
  • h_time
  • h_place
  • u_id — varchar2 — Foreign key → user.u_id — NOT NULL

helperVid

  • h_id — Foreign key → help.h_id
  • h_url

request

  • a_id — Foreign key → accident.a_id — NOT NULL
  • u_id — varchar2 — Foreign key → user.u_id — NOT NULL
  • req_time (r_time) — varchar2
  • req_payment — varchar2

response

  • a_id — Foreign key → request.a_id — NOT NULL
  • u_id — varchar2 — Foreign key → request.u_id — NOT NULL
  • h_id — Foreign key → help.h_id
  • resp_time
  • resp_payment

user

  • u_id — varchar2 — Primary key — NOT NULL
  • u_name — varchar2
  • u_pwd — varchar2
  • u_alias — varchar2
  • u_phone — varchar2