stackoverflow

Tables (9)

answer (답변)

  • id (아이디) — Long — Primary key — NOT NULL
  • body (내용) — String
  • created_at (작성 날짜) — Date
  • modified_at (수정 날짜) — Date
  • recommendation (추천수) — Long
  • question_id (질문 아이디) — Long — Foreign key → question.id — NOT NULL
  • writor_id (작성자 아이디) — Long — Foreign key → user.id — NOT NULL
  • editor_id (편집자 아이디) — Long — Foreign key → user.id — NOT NULL

comment (대댓글)

  • id (아이디) — Long — Primary key — NOT NULL
  • question_id (질문 아이디) — Long — Foreign key → question.id — NOT NULL
  • answer_id (답변 아이디) — Long — Foreign key → answer.id — NOT NULL
  • user_id (유저 아이디) — Long — Foreign key → user.id — NOT NULL
  • body (내용) — Long
  • created_at (작성 날짜) — Long

image (Untitled6)

  • id (아이디) — Long — Primary key — NOT NULL
  • name (파일이름) — varchar2
  • extension (확장자) — varchar2
  • route (경로) — varchar2
  • create_at (생성일) — date

question (Untitled3)

  • id (아이디) — Long — Primary key — NOT NULL
  • title (제목) — String
  • body (내용) — String
  • created_at (작성 날짜) — Date
  • modified_at (수정 날짜) — Date
  • view (조회수) — Long
  • recommendation (추천수) — Long
  • editor_id (편집자 아이디) — Long — Foreign key → user.id — NOT NULL
  • writor_id (작성자 아이디) — Long — Foreign key → user.id — NOT NULL

question_tag (Untitled9)

  • id (아이디) — Long — Primary key — NOT NULL
  • question_id (질문 아이디) — Long — Foreign key → question.id — NOT NULL
  • tag_id (태그 아이디) — Long — Foreign key → tag.id — NOT NULL

subscription (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • question_id (질문글아이디) — Long — Foreign key → question.id — NOT NULL
  • answer_id (답변아이디) — Long — Foreign key → answer.id — NOT NULL
  • user_id (유저아이디) — Long — Foreign key → user.id — NOT NULL

tag (Untitled4)

  • id (아이디) — Long — Primary key — NOT NULL
  • name (이름) — varchar2
  • description (설명) — varchar2

user (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • created_at (가입날짜) — Date
  • reputation (명성치) — Integer
  • display_name (닉네임) — String
  • title (간략설명?) — String
  • about_me (자기소개) — String
  • location (지역) — String
  • website_link (웹사이트링크) — String
  • twitter_link (트위터 링크) — String
  • github_link (깃허브링크) — String

user_tag (Untitled8)

  • id (아이디) — Long — Primary key — NOT NULL
  • tag_id (태그 아이디) — Long — Foreign key → tag.id — NOT NULL
  • user_id (유저 아이디) — Long — Foreign key → user.id — NOT NULL