오나코 ERD

테이블 (11)

answer (Untitled5)

  • answerId (Key) — int — 기본 키 — NOT NULL
  • userid (Key2) — varchar(20) — 외래 키 → user.userId — NOT NULL
  • questionId (Key3) — int — 외래 키 → question.questionId — NOT NULL
  • answerTitle (Field) — varchar(200) — NOT NULL
  • answerContent (Field2) — varchar(2000) — NOT NULL
  • answerDate (Field3) — datetime — NOT NULL
  • likes (Field4) — int(11) — NOT NULL

article (Untitled7)

  • articleId (Key) — int(11) — 기본 키 — NOT NULL
  • blogid (Key2) — int(11) — 외래 키 → blog.blogid — NOT NULL
  • title (Field) — varchar(100) — NOT NULL
  • content (Field2) — varchar(200)
  • link (Field3) — varchar(500) — NOT NULL
  • image (Field5) — varchar2(500)
  • publisheddate (Field6) — datetime

blog (CopyOfUntitled7)

  • blogid (Key) — int(11) — 기본 키 — NOT NULL
  • blogname (Field) — varchar(30) — NOT NULL
  • description (Field2) — varchar(50)
  • link (Field3) — varchar(200)
  • blogid (Field4) — varchar(200) — NOT NULL

category (Untitled2)

  • categoryid (Key) — varchar(20) — 기본 키 — NOT NULL
  • categoryname (Field) — varchar(20) — NOT NULL

positions (Position)

  • positionId (Key) — int(11) — 기본 키 — NOT NULL
  • positionName (Field) — varchar(20) — NOT NULL

question (Question)

  • questionId (Key) — int(11) — 기본 키 — NOT NULL
  • userid (Key2) — varchar(20) — 외래 키 → user.userId — NOT NULL
  • questionTitle (Field) — varchar(200) — NOT NULL
  • questionContent (Field2) — varchar(2000) — NOT NULL
  • questionDate (Field3) — datetime — NOT NULL
  • views (Field4) — int — NOT NULL
  • likes (Field5) — int(11) — NOT NULL

subscribe (CopyOfCopyOfUntitled7)

  • userId — varchar(20) — 외래 키 → user.userId — NOT NULL
  • blogid (Key2) — int(11) — 외래 키 → blog.blogid — NOT NULL

tag (Untitled8)

  • tagId (Key) — int — 기본 키 — NOT NULL
  • tagName (Field) — varchar(20) — NOT NULL

tag_relation (Untitled9)

  • tagId (Key3) — int — 외래 키 → tag.tagId — NOT NULL
  • questionId (Key4) — int — 외래 키 → question.questionId — NOT NULL

todo (Untitled3)

  • todoid (Key) — varchar(40) — 기본 키 — NOT NULL
  • categoryid (Key2) — varchar(20) — 외래 키 → category.categoryid — NOT NULL
  • userid (Key3) — varchar(20) — 외래 키 → user.userId — NOT NULL
  • date (Field) — date — NOT NULL
  • title (Field2) — varchar2(50) — NOT NULL
  • goaltime (Field3) — time — NOT NULL
  • isSuccess (Field4) — bit(1) — NOT NULL
  • completeTime (Field5) — time — NOT NULL
  • created (Field6) — datetime — NOT NULL
  • ongoing (Field7) — bit(1)

user

  • userId — varchar(20) — 기본 키 — NOT NULL
  • positionId — int(11) — 외래 키 → positions.positionId — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • email — varchar(30) — NOT NULL
  • password — varchar(100)
  • githubid (githubId) — varchar(30)
  • social — varchar(20)
  • image (Field) — varchar(200)