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)