오나코 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)