passport

Tables (4)

account

  • aid — varchar2(50) — Primary key — NOT NULL
  • pwd — varchar2(100)
  • email — varchar2(100)
  • role — varchar2(30)

comparison_data

  • c_passport_no — number — Primary key — NOT NULL
  • c_org_img — varchar2(20)
  • c_light_img — varchar2(100)
  • c_country — varchar2(30)

input_data

  • i_passport_no — number — Primary key — NOT NULL
  • i_org_img — varchar2(100)
  • i_light_img — varchar2(100)
  • i_name — varchar2(30)
  • i_country — varchar2(30)

result

  • r_no — number — Primary key — NOT NULL
  • r_content — varchar2(20)
  • r_date — date
  • i_passport_no — number — Foreign key → input_data.i_passport_no — NOT NULL
  • c_passport_no — number — Foreign key → comparison_data.c_passport_no — NOT NULL
  • aid — varchar2(50) — Foreign key → account.aid — NOT NULL