aboutmatch

Tables (3)

Member

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (memberId) — VARCHAR(30) — NOT NULL
  • Field2 (memberEmail) — VARCHAR(60) — NOT NULL
  • Field3 (memberPwd) — VARCHAR(40) — NOT NULL
  • Field4 (memberAddress) — VARCHAR(60) — NOT NULL
  • Field (memberName) — VARCHAR(30) — NOT NULL

Untitled (Board)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (title) — VARCHAR(60) — NOT NULL
  • Field2 (content) — VARCHAR(600) — NOT NULL
  • Field3 (time) — DATETIME — NOT NULL
  • Field4 (good) — INTEGER — NOT NULL
  • Key (memid) — INTEGER — Foreign key → Member.Key — NOT NULL

Untitled (record)

  • Field2 (name) — VARCHAR(40) — NOT NULL
  • Field3 (matchNum) — VARCHAR(40) — NOT NULL
  • Field4 (score) — VARCHAR(40) — NOT NULL
  • Field (assist) — VARCHAR(40) — NOT NULL
  • Field (backNum) — VARCHAR(40) — NOT NULL