헬프로미스

테이블 (8)

Copy Of Untitled (group-schedule)

  • Key (usNum) — int — 기본 키 — NOT NULL
  • Key (gid) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — varhcar
  • Field (content) — varhcar
  • Field (location) — varchar
  • Field (startTime) — date
  • Field (endTime) — date

Untitled (user)

  • Key (uNum) — int — 기본 키 — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (password) — varchar
  • Field (email) — varhcar — NOT NULL

Untitled (board)

  • Key (bNum) — int — 기본 키 — NOT NULL
  • Key (userNum) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — varchar
  • Field (date) — date — NOT NULL

Untitled (favoriteUSer)

  • Key (fNum) — int — 기본 키 — NOT NULL
  • Key (uNum) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field2 (favoriteNum) — int — NOT NULL

Untitled (alarm)

  • Key (aNum) — int — 기본 키 — NOT NULL
  • Key (uNum) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — varhcar — NOT NULL

Untitled (user-schedule)

  • Key (usNum) — int — 기본 키 — NOT NULL
  • Key (uNum) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — varhcar
  • Field (content) — varhcar
  • Field (location) — varchar
  • Field (startTime) — date
  • Field (endTime) — date

Untitled (department)

  • Key (dNm) — int — 기본 키 — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (member)

Untitled (group)

  • Key (gid) — int — 기본 키 — NOT NULL
  • Field (name) — varhcar — NOT NULL