Connector
Tables (13)
BOARD
- PK (boardno) — INT — Primary key — NOT NULL
- PK (userno) — INT — Foreign key → USER.PK — NOT NULL
- Field2 (title) — varchar(100)
- Field3 (content) — varchar(1000)
- Field4 (bdate) — datetime
CATEGORY
- PK (cateno) — INT — Primary key — NOT NULL
- Field (cname) — varchar(50)
CITYCODE (Untitled)
- Key (citycode) — INT — Primary key — NOT NULL
- Field (cityname) — varchar(20)
COMMENT
- PK (commno) — INT — Primary key — NOT NULL
- FK (boardno) — INT — Foreign key → BOARD.PK — NOT NULL
- FK (userno) — INT — Foreign key → USER.PK — NOT NULL
- Field2 (content) — verchar(1000)
- Field3 (cdate) — datetime
DONGCODE (Untitled3)
- Key (dongcode) — INT — Primary key — NOT NULL
- Field (dongname) — varchar(20)
FOLLOW
- PK (folno) — INT — Primary key — NOT NULL
- FK (userno) — INT — Foreign key → USER.PK — NOT NULL
- FK (prono) — INT — Foreign key → USER.PK — NOT NULL
GUCODE (Untitled2)
- Key (gucode) — INT — Primary key — NOT NULL
- Field (guname) — varchar(20)
MSG
- PK (msgno) — INT — Primary key — NOT NULL
- FK (writerno) — INT — Foreign key → USER.PK — NOT NULL
- FK (receiverno) — INT — Foreign key → USER.PK — NOT NULL
- Field3 (title) — varchar(100)
- Field4 (content) — varchar(1000)
- Field5 (senddate) — datetime
PAY
- PK (payno) — INT — Primary key — NOT NULL
- FK (servno) — INT — Foreign key → SERVICE.PK — NOT NULL
- FK (userno) — INT — Foreign key → USER.PK — NOT NULL
QNA
- PK (qnano) — INT — Primary key — NOT NULL
- FK (userno) — INT — Foreign key → USER.PK — NOT NULL
- Field2 (qtitle) — varchar(100)
- Field3 (qcontent) — varchar(1000)
- Field4 (awriter) — varchar(20)
- Field5 (acontent) — varchar(1000)
- Field6 (qdate) — datetime
- Field7 (adate) — datetime
REVIEW
- PK (revno) — INT — Primary key — NOT NULL
- FK (userno) — INT — Foreign key → USER.PK — NOT NULL
- FK (servno) — INT — Foreign key → SERVICE.PK — NOT NULL
- Field (title) — varchar(100)
- Field2 (content) — varchar(1000)
- Field3 (point) — INT
- Field (cdate) — datetime
SERVICE
- PK (servno) — INT — Primary key — NOT NULL
- FK (userno) — INT — Foreign key → USER.PK — NOT NULL
- FK (cateno) — INT — Foreign key → CATEGORY.PK — NOT NULL
- Field (servname) — varchar(100)
- Field2 (price) — INT
- Field3 (discription) — varchar(1000)
- Field (seraddr) — varchar(1000)
USER
- PK (userno) — INT — Primary key — NOT NULL
- Field5 (email) — varchar(100)
- Field2 (pw) — varchar(20)
- Field3 (name) — varchar(20)
- Field4 (tel) — varchar(20)
- Field (addr) — varchar(200)
- Field2 (ispro) — boolean