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