project

Tables (5)

board (Untitled3)

  • boardid (Key) — number — Primary key — NOT NULL
  • userid (varchar2(50)) — varchar2(100) — Foreign key → user.userid — NOT NULL
  • categoryid (Key2) — number — Foreign key → category.categoryid — NOT NULL
  • title (Field) — varchar2(100)
  • detail (Field2) — varchar2(4000)
  • regdate (Field4) — date
  • updatedate (Field3) — date

category (Untitled4)

  • categoryid (Key) — number — Primary key — NOT NULL
  • categoryname (Field) — varchar2(100)

comment (Untitled5)

  • commnetid (Key) — number — Primary key — NOT NULL
  • boardid (Key2) — number — Foreign key → board.boardid — NOT NULL
  • userid (varchar2(50)) — varchar2(100) — Foreign key → board.userid — NOT NULL
  • comment (Field) — varchar2(4000)
  • regdate (Field2) — date

company (Untitled2)

  • companyid (Key) — number — Primary key — NOT NULL
  • companyname (Field) — varchar2(100)
  • companynumber (Field2) — number
  • companyaddress (Field3) — varchar2(100)

user (Untitled)

  • userid (varchar2(50)) — varchar2(100) — Primary key — NOT NULL
  • userpw (Field) — varchar2(100)
  • username (Field2) — varchar2(100)
  • usernumber (Field3) — varchar2(100)
  • companyid (Key) — number — Foreign key → company.companyid — NOT NULL