Interview-reviews

테이블 (8)

공통시간 (BaseTime)

  • created_date (Field) — LocalDateTime
  • modified_date (Field2) — LocalDateTime

커뮤니티 (Community)

  • community_id (Key) — Long — 기본 키 — NOT NULL
  • member_id (Key2) — Long — 외래 키 → 회원.member_id — NOT NULL
  • title (Field) — String
  • contents (Field2) — String
  • category (Field3) — Community_Type

커뮤니티 댓글 (Community_COMMENT)

  • community_commemt_id (Key) — Long — 기본 키 — NOT NULL
  • community_id (Key2) — Long — 외래 키 → 커뮤니티.community_id — NOT NULL
  • Field — String

커뮤니티 좋아요 (Community_Like)

  • community_like_id (Key3) — Long — 기본 키 — NOT NULL
  • community_id (Key) — Long — 외래 키 → 커뮤니티.community_id — NOT NULL
  • member_id (Key2) — Long — 외래 키 → 커뮤니티.member_id — NOT NULL

커뮤니티 태그 (Community_Tag)

  • Community_Tag_id (Key) — Long — 기본 키 — NOT NULL
  • community_id (Key2) — Long — 외래 키 → 커뮤니티.community_id — NOT NULL
  • tag_name (Field) — String

회원 (Member)

  • member_id (Key) — Long — 기본 키 — NOT NULL
  • memberdetail_id (Key2) — Long — 외래 키 → 회원정보.memberdetail_id — NOT NULL
  • nickname (Field) — String
  • user_id (Field2) — String
  • password (Field3) — String
  • membername (Field15) — String
  • phone_num (Field16) — String
  • email (Field4) — String
  • birth_date (Field5) — LocalDataTime
  • gender (Field6) — Gender_Type

회원정보 (MemberDetail)

  • memberdetail_id (Key) — Long — 기본 키 — NOT NULL
  • Field

후기글 (Review)

  • review_id (Key) — Long — 기본 키 — NOT NULL
  • member_id (Key2) — Long — 외래 키 → 회원.member_id — NOT NULL
  • title (Field) — String
  • contents (Field2) — String
  • nickname (Field3) — String
  • difficulty (Field4) — Double
  • type (Field5) — String
  • support_date (Field6) — LocalDate
  • passingStatus (Field7) — Boolean
  • career (Field8) — Integer