웹시스템 erd

테이블 (4)

bbs (Untitled2)

  • bbsID (Key) — int — 기본 키 — NOT NULL
  • bbsTitle (Field) — varchar
  • bbsDate (Field2) — datetime
  • bbsContent (Field3) — varchar
  • bbsAvailable (Field4) — int
  • salary (Field5) — varchar
  • category (Field6) — varchar
  • deadline (Field7) — varchar
  • bbs_phone (Field8) — varchar
  • file (Field9) — varchar
  • user_id (Key2) — varchar — 외래 키 → user.user_id — NOT NULL

jjim (Untitled3)

  • bbsID (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — varchar — 기본 키 — NOT NULL
  • bbsID (Key3) — int — 외래 키 → bbs.bbsID — NOT NULL

portfolio (Untitled4)

  • projectName (Field) — varchar
  • aboutProject (Field2) — varchar
  • projectFile (Field3) — varchar
  • user_id (Key) — varchar — 외래 키 → user.user_id — NOT NULL

user (Untitled)

  • user_id (Key) — varchar — 기본 키 — NOT NULL
  • passwd (Field) — varchar
  • username (Field1) — varchar
  • nickname (Field2) — varchar
  • address (Field3) — varchar
  • phone (Field4) — varchar