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