컴퓨터조립
테이블 (5)
ComEstimate (Untitled2)
- ComEstimateID (Key) — int — 기본 키 — NOT NULL
- userID (Key2) — String — 외래 키 → user.userID — NOT NULL
- cpuInfo (Field) — String
- MainBoard (Field2) — String
- RAM (Field3) — String
- Storage1 (Field4) — String
- Storage2 (Field5) — String
- Power (Field6) — String
- CPUFan (Field7) — String
- CaseFan (Field8) — String
- CaseType (Field9) — String
bbs (Untitled3)
- bbsID (Key2) — int — 기본 키 — NOT NULL
- userID (Key) — String — 외래 키 → user.userID — NOT NULL
- ComEstimateID (Key3) — int — 외래 키 → ComEstimate.ComEstimateID — NOT NULL
- bbsContent (Field) — varChar(1500)
- bbsTitle (Field2) — varChar(100)
- RecommendUserIDs (Field3) — int
- Recommend (Field4) — int
- NonRecommendCount (Field6) — int
- writingTime (Field5) — String
- editTime (Field7) — String
comment (Untitled4)
- bbsID (Key2) — int — 외래 키 → bbs.bbsID — NOT NULL
- ComEstimateID (Key3) — int — 외래 키 → bbs.ComEstimateID — NOT NULL
- userID (Key) — String — 외래 키 → user.userID — NOT NULL
- comContent (Field) — varChar(500)
- writingTime (Field2) — String
- editTime (Field3) — String
notice (Untitled5)
- noticeID (Key2) — int — 기본 키 — NOT NULL
- userID (Key) — String — 외래 키 → user.userID — NOT NULL
- noticeContent (Field) — String
user (Untitled)
- userID (Key) — String — 기본 키 — NOT NULL
- userPassword (Field) — String
- userName (Field2) — String
- AllRecommend (Field3) — int
- userProfile (Field4) — String
- isAccept (Field5) — bool