Toss

Tables (4)

Untitled (SIGNUP)

  • EMAIL — VARCHAR2(40) — Primary key — NOT NULL
  • PASSWORD — VARCHAR2(40)
  • NAME — VARCHAR2(30)
  • PHONE — VARCHAR2(30)

Untitled (CARD)

  • Key (CARDNUM) — INTEGER — Primary key — NOT NULL
  • EMAIL — VARCHAR2(40) — Foreign key → Untitled.EMAIL — NOT NULL
  • Field (PERIOD) — VARCHAR2(10)
  • Field (CVC) — VARCHAR2(10)
  • Field (CARDPWD) — VARCHAR2(10)
  • Field (BANKNAME) — VARCHAR2(30)

Untitled (ACCOUNT)

  • ACCNUM — INTEGER — Primary key — NOT NULL
  • EMAIL — VARCHAR2(40) — Foreign key → Untitled.EMAIL — NOT NULL
  • Key (CARDNUM) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Field (MONEY) — VARCHAR2(40)

Untitled (TIMELINE)

  • Key (TIMENUM) — INTEGER — Primary key — NOT NULL
  • EMAIL — VARCHAR2(40) — Foreign key → Untitled.EMAIL — NOT NULL
  • Key (CARDNUM) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Field (RECEIVER) — VARCHAR2(40)
  • Field (SENTMONEY) — VARCHAR2(40)
  • Field (RECEIVEMONEY) — VARCHAR2(40)
  • Field (WHENTIME) — VARCHAR2(30)