웹시스템 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