asdf

테이블 (12)

Untitled6

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR — NOT NULL
  • extension — VARCHAR — NOT NULL
  • route — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL

location (Untitled2)

  • id (pk) — 기본 키 — NOT NULL
  • member_id (fk) — 외래 키 → member.id — NOT NULL
  • city (Field)

member (Untitled)

  • id (pk) — 기본 키 — NOT NULL
  • company_type (Field)
  • company_location (Field2)
  • name (Field3)
  • password (Field4)
  • sex (Field5)

type (Untitled3)

  • id (pk) — 기본 키 — NOT NULL
  • member_id (pk2) — 외래 키 → member.id — NOT NULL
  • name (Field)

구독

  • id — BIGINT — 기본 키 — NOT NULL
  • question_id — BIGINT
  • answer_id — BIGINT
  • user_id — BIGINT — NOT NULL

답변

  • id — BIGINT — 기본 키 — NOT NULL
  • body — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL
  • recommendation — BIGINT
  • question_id — BIGINT — NOT NULL
  • writor_id — BIGINT — NOT NULL
  • editor_id — BIGINT

대댓글

  • id — BIGINT — 기본 키 — NOT NULL
  • question_id — BIGINT
  • answer_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • body — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL

유저

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • reputation — BIGINT
  • display_name — VARCHAR(20) — NOT NULL
  • title — VARCHAR(50)
  • about_me — VARCHAR(200)
  • location — VARCHAR(100)
  • website_link — VARCHAR(100)
  • twitter_link — VARCHAR(100)
  • github_link — VARCHAR(100)

유저_태그

  • id — BIGINT — 기본 키 — NOT NULL
  • tag_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL

질문

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • body — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME
  • view — BIGINT
  • recommendation — BIGINT
  • editor_id — BIGINT
  • writor_id — BIGINT — NOT NULL

질문_태그

  • id — BIGINT — 기본 키 — NOT NULL
  • question_id — BIGINT — NOT NULL
  • tag_id — BIGINT — NOT NULL

태그

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR — NOT NULL
  • description — VARCHAR