2
Tables (9)
BOARD
- BOARDID — VARCHAR(100) — NOT NULL
- CONTENT — VARCHAR(100)
- ID — VARCHAR(100) — NOT NULL — JAVA, JS, CSS
- SUBJECT — VARCHAR(100) — NOT NULL — 010-1234-5678
- DATE — DATE — NOT NULL
- HIT — VARCHAR(100) — NOT NULL
CHATING
- USERID2 — VARCHAR(100) — Foreign key → CHATINGROOM.USERID — NOT NULL — hong
- PROJECTID — VARCHAR(100) — Foreign key → CHATINGROOM.PROJECTID — NOT NULL
- TIME — VARCHAR(100)
- USERNAME — VARCHAR(100)
- MESSAGE — VARCHAR(100)
CHATINGROOM
- USERID — VARCHAR(100) — Foreign key → PROJECTMEMBER.USERID — NOT NULL — hong
- PROJECTID — VARCHAR(100) — Foreign key → PROJECTMEMBER.PROJECTID — NOT NULL
- CHATID — VARCHAR(100)
- CHATINGNAME — VARCHAR(100)
- CURRENTJOIN — VARCHAR(100)
- MAXJOIN — VARCHAR(100)
COMMENT
- No — INT — NOT NULL — 게시물 ID
- BOARDID — VARCHAR(100) — NOT NULL — 2023-01-01
- DATE — DATE
PROJECT
- PROJECTID — VARCHAR(100) — NOT NULL
- READERID — VARCHAR(100) — NOT NULL
- PROJECTNAME — VARCHAR(100) — NOT NULL
- CREATEDATE — DATE — NOT NULL
- MAXJOIN — VARCHAR(100) — NOT NULL
PROJECTMEMBER
- USERID — VARCHAR(100) — Foreign key → USER.ID — NOT NULL — 홍길동
- PROJECTID — VARCHAR(100) — Foreign key → PROJECT.PROJECTID — NOT NULL
READER
- PROJECTID — VARCHAR(100) — Foreign key → PROJECT.PROJECTID — NOT NULL
- READERID — VARCHAR(100) — Foreign key → PROJECT.READERID — NOT NULL
- Field — BOOLEAN — NOT NULL
- Field2 — BOOLEAN — NOT NULL
- Field3 — BOOLEAN — NOT NULL
- Field4 — BOOLEAN — NOT NULL
TAG
- BOARDID — VARCHAR(100) — Foreign key → BOARD.BOARDID — NOT NULL
- CONTENT — VARCHAR(100) — Foreign key → BOARD.CONTENT
USER
- ID — VARCHAR(100) — NOT NULL — hong
- PWD — VARCHAR(100) — NOT NULL — 1234
- NAME — VARCHAR(100) — NOT NULL — 홍길동
- BIRTH — DATE — NOT NULL — 1996-08-07
- SKILL — VARCHAR(100) — JAVA, JS, CSS
- EMAIL — VARCHAR(100) — NOT NULL
- PHONE — VARCHAR(100) — NOT NULL — 010-1234-5678
- HIREDATE — DATE — NOT NULL — 2024-03-01