whitebox
Tables (4)
AUTHENTICATIONRESULT
- AUR_CODE — CHAR(2) — Primary key
- AUR_NAME — NVARCHAR2(5)
BUYER
- BUY_ID — NVARCHAR2(500) — Primary key
- BUY_PASSWORD — CHAR(60) — NOT NULL
- BUY_LASTNAME — NVARCHAR2(500) — NOT NULL
- BUY_FIRSTNAME — NVARCHAR2(500) — NOT NULL
- BUY_PHONE — NVARCHAR2(500) — NOT NULL
- BUY_EMAIL — NVARCHAR2(500) — NOT NULL
- BUY_ADDRESS — NVARCHAR2(500) — NOT NULL
- BUY_POSTAL — NVARCHAR2(500) — NOT NULL
- BUY_GENDER — NVARCHAR2(500) — NOT NULL
- BUY_BIRTHDAY — DATE — NOT NULL
- BUY_IMAGE — NVARCHAR2(500)
SELLER
- SEL_ID — NVARCHAR2(500) — Primary key
- SEL_PASSWORD — CHAR(60) — NOT NULL
- SEL_SHOPNAME — NVARCHAR2(20) — NOT NULL
- SEL_INFO — NVARCHAR2(2000) — NOT NULL
- SEL_LASTNAME — NVARCHAR2(500) — NOT NULL
- SEL_FIRSTNAME — NVARCHAR2(500) — NOT NULL
- SEL_PHONE — NVARCHAR2(500) — NOT NULL
- SEL_EMAIL — NVARCHAR2(500) — NOT NULL
- SEL_ADDRESS — NVARCHAR2(500) — NOT NULL
- SEL_IMAGE — NVARCHAR2(500) — NOT NULL
SELLERAUTHENTICATION
- SAU_SELID — NVARCHAR2(500) — Primary key
- SAU_DATE — DATE
- SAU_AURCODE — CHAR(2) — Foreign key → AUTHENTICATIONRESULT.AUR_CODE
- AUR_CODE — CHAR(2) — Foreign key → AUTHENTICATIONRESULT.AUR_CODE