ZUC
Tables (6)
Board (게시판의 정보)
- boardNo (PK UQ AI) — INT — Primary key — NOT NULL
- labelName (PK UQ2) — VARCHAR(50) — Foreign key → Labels.labelName — NOT NULL
- id (PK, UQ) — VARCHAR(30) — Foreign key → Users.id — NOT NULL
- entitle (PK UQ3) — TEXT — Foreign key → Users.entitle — NOT NULL
- title (Field) — TEXT
- content (Field2) — TEXT
Entitles (칭호 정보)
- entitle (PK UQ) — TEXT — Primary key — NOT NULL
- code (Field) — TEXT
Labels (게시판 라벨 정보)
- labelName (PK UQ) — VARCHAR(50) — Primary key — NOT NULL
Links (링크 정보)
- URL (PK UQ) — TEXT — Primary key — NOT NULL
- name (UQ) — TEXT
Mail (쪽지 정보)
- mailNo (PK UQ AI) — INT — Primary key — NOT NULL
- to (Field) — VARCHAR(30)
- from (Field2) — VARCHAR(30)
- content (Field3) — TEXT
Users (사용자의 정보)
- id (PK, UQ) — VARCHAR(30) — Primary key — NOT NULL
- entitle (PK UQ) — TEXT — Foreign key → Entitles.entitle — NOT NULL
- pw (Field) — VARCHAR(30)
- warn (Field2) — INT
- nickname (Field3) — VARCHAR(30)
- phone (Field4) — VARCHAR(30)