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)