투자 관련 Q&A 사이트 ERD

테이블 (11)

Answer (Untitled3)

  • Answer_id PK (Key2) — 기본 키 — NOT NULL
  • question_id FK (Key) — 외래 키 → User.user_id pk — NOT NULL
  • user_id FK (Field)

AnswerVote (Untitled8)

  • user_id FK (Field)
  • answer_id FK (Field2)

BookMark (Untitled6)

  • user_id FK (Field)
  • Field2

Comment (Untitled9)

  • comment_id PK (Key) — 기본 키 — NOT NULL
  • answr_id FK (Field)
  • user_id FK (Field2)
  • Answer_id PK (Key2) — 외래 키 → Answer.Answer_id PK — NOT NULL

Question (Untitled2)

  • Question_id PK (Key2) — 기본 키 — NOT NULL
  • user_id FK (Key) — 외래 키 → User.user_id pk — NOT NULL
  • title, body (Field)

QuestionTag (Untitled5)

  • Question_id PK (Key2) — 외래 키 → Question.Question_id PK — NOT NULL
  • tga_id FK (Field)

QuestionVote (Untitled7)

  • user_id FK (Field)
  • Question_id FK (Field2)

Tag (Untitled4)

  • tag_id PK (Key) — 기본 키 — NOT NULL
  • name (Field)

Untitled10

  • ticker_id PK (Key) — 기본 키 — NOT NULL
  • symbol, market (Field)

Untitled11

  • question_id FK (Key) — 외래 키 → Untitled10.ticker_id PK — NOT NULL
  • ticker_id FK (Field2)

User (Untitled)

  • user_id pk (Key) — 기본 키 — NOT NULL
  • email (Field)
  • nickname (Field2)