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