plLog

Tables (4)

comment (Untitled)

  • PK (commentID) — int — Primary key — NOT NULL
  • PK (boardID) — int — Foreign key → post.PK — NOT NULL
  • PK (userID) — varchar(20) — Foreign key → users.PK — NOT NULL
  • (content)
  • (writeTime) — tempstamp
  • (location) — decimal(13, 10)

post (.)

  • PK (boardID) — int — Primary key — NOT NULL
  • PK (writerID) — varchar(20) — Primary key — NOT NULL
  • (content) — varchar(500)
  • (writeTime) — timestamp
  • Field (location)

tempSearch (Untitled4)

  • PK (searchID) — int — Primary key — NOT NULL
  • FK (writerID) — varchar(20) — Primary key — NOT NULL
  • (location) — decimal(13, 10)
  • (Field2) — varchar(100)

users (Untitled3)

  • PK (userID) — varchar(20) — Primary key — NOT NULL
  • (userName) — varchar(20)
  • (userEmail) — varchar(50)
  • (nickname) — varchar(20)
  • (userpwd) — varchar(20)