컴퓨터조립

테이블 (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