3
Tables (9)
BOARD
- BOARDID — VARCHAR(100) — NOT NULL
- CONTENT — VARCHAR(100)
- ID — VARCHAR(100) — Foreign key → USER.ID — NOT NULL
- DATE — DATE
- FILE — VARCHAR(100) — NOT NULL
- HIT — VARCHAR(100) — NOT NULL
- No — VARCHAR(100) — NOT NULL
CHATING
- USERID2 — VARCHAR(100) — Foreign key → USER.ID — NOT NULL — hong
- PROJECTID — VARCHAR(100) — Foreign key → PROJECT.PROJECTID — NOT NULL
- TIME — TIMESTAMP
- USERNAME — VARCHAR(100)
- MESSAGE — VARCHAR(100)
CHATINGROOM
- USERID — VARCHAR(100) — Foreign key → USER.ID — NOT NULL — hong
- PROJECTID — VARCHAR(100) — Foreign key → PROJECT.PROJECTID — NOT NULL
- CHATID — VARCHAR(100)
- CHATINGNAME — VARCHAR(100)
- CURRENTJOIN — VARCHAR(100)
- MAXJOIN — VARCHAR(100)
COMMENT
- No — INT — NOT NULL — 게시물 ID
- BOARDID — VARCHAR(100) — Foreign key → BOARD.BOARDID — NOT NULL — 2023-01-01
- DATE — DATE — 게시물 ID
- COMMENT — 'hong' — hong
- _TEXT — VARCHAR(100)
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
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 — hong
- CONTENT — VARCHAR(100)
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