투자 관련 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)
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)