stackoverflow

테이블 (10)

MEMBER_ROLE (Untitled)

  • memberId (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
  • roles (ROLES) — VARCHAR(255)

Untitled (QUESTION_COMMENT)

  • Key (QUESTION_COMMENT_ID) — bigint — 기본 키 — NOT NULL — Auto Increment
  • id (QUESTION_ID) — bigint — 외래 키 → 질문.id — NOT NULL — Auto Increment
  • id (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
  • Field (CONTENT) — text — NOT NULL
  • Field2 (CREATED_AT) — datetime — NOT NULL
  • Field3 (MODIFIED_AT) — datetime — NOT NULL

Untitled (TAG)

  • Key (TAG_ID) — bigint — 기본 키 — NOT NULL — Auto Increment
  • Field (TAG_NAME) — varchar(255) — NOT NULL
  • Field2 (TAG_DESCRIPTION) — varchar(255)
  • Field (CREATED_AT) — datetime — NOT NULL
  • Field2 (MODIFIED_AT) — datetime — NOT NULL

Untitled (QUESTION_TAG)

  • Key (QUESTION_TAG_ID) — bigint — 기본 키 — NOT NULL
  • id (QUESTION_ID) — bigint — 외래 키 → 질문.id — NOT NULL — Auto Increment
  • Key (TAG_ID) — bigint — 외래 키 → Untitled.Key — NOT NULL — Auto Increment
  • Field (CREATED_AT) — datetime — NOT NULL
  • Field2 (MODIFIED_AT) — datetime — NOT NULL

Untitled (ANSWER)

  • Key (ANSWER_ID) — bigint — 기본 키 — NOT NULL
  • id (QUESTION_ID) — bigint — 외래 키 → 질문.id — NOT NULL — Auto Increment
  • id (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
  • Field (CONTENT) — text — NOT NULL
  • Field2 (ACCEPTED) — boolean — NOT NULL
  • Field (CREATED_AT) — datetime — NOT NULL
  • Field2 (MODIFIED_AT) — datetime — NOT NULL

Untitled (ANSWER_COMMENT)

  • Key (ANSWER_COMMENT_ID) — bigint — 기본 키 — NOT NULL
  • id (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
  • Key (ANSWER_ID) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (CONTENT) — TEXT — NOT NULL
  • Field2 (CREATED_AT) — datetime — NOT NULL
  • Field3 (MODIFED_AT) — datetime — NOT NULL

Untitled (VOTE)

  • Key (VOTE_ID) — bigint — 기본 키 — NOT NULL
  • id (VOTER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
  • id (QUESTION_ID) — bigint — 외래 키 → 질문.id — NOT NULL — Auto Increment
  • Key (ANSWER_ID) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • voteStatus (VOTE_STATUS) — varhcar(255)

Untitled2

  • profileImageId (PROFILE_IMAGE_ID) — bigint — 기본 키 — NOT NULL
  • memberId (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
  • uploadFileName (UPLOAD_FILE_NAME) — varchar(255)
  • storeFIleName (STORE_FILE_NAME) — varchar(255)
  • createdAt (CREATED_AT) — datetime
  • modifiedAt (MODIFIED_AT) — datetime

질문 (QUESTION)

  • id (QUESTION_ID) — bigint — 기본 키 — NOT NULL — Auto Increment
  • id (MEMBER_ID) — bigint — 외래 키 → 회원.id — NOT NULL — Auto Increment
  • title (QUESTION_TITLE) — varchar(255) — NOT NULL
  • content (CONTENT) — text — NOT NULL
  • view (VIEWS) — int — NOT NULL
  • adopt (IS_ADOPTED) — boolean
  • Field (CREATED_AT) — datetime — NOT NULL
  • Field2 (MODIFIED_AT) — datetime — NOT NULL

회원 (MEMBER)

  • id (MEMBER_ID) — bigint — 기본 키 — NOT NULL — Auto Increment
  • email (EMAIL) — varchar(255) — NOT NULL
  • password (PASSWORD) — varchar(255) — NOT NULL
  • displayName (USER_NAME) — varchar(255) — NOT NULL
  • createdAt (CREATED_AT) — datetime — NOT NULL
  • modifiedAt (MODIFIED_AT) — datetime — NOT NULL
  • reputation — int
  • Field2