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