꾸독

테이블 (13)

Category (category)

  • categoryId (category_id) — Long — 기본 키 — NOT NULL
  • categoryName (category_name) — varchar
  • categoryEng (category_eng) — varchar
  • categoryImage (category_image) — varchar

EventSubs (event_subs)

  • eventId (event_id) — Long — 기본 키 — NOT NULL
  • infoTag (info_tag) — varchar
  • subsId (subs_id) — Long — 외래 키 → Subs.subsId — NOT NULL
  • info — varchar
  • eventImage (event_image) — varchar
  • startDate (start_date) — DateTime
  • endDate (end_date) — DateTime
  • isValid (is_valid) — boolean

Member (member)

  • memberId (member_id) — Long — 기본 키 — NOT NULL
  • memberName (member_name) — varchar
  • age — int
  • loginId (login_id) — varchar
  • password — varchar
  • gender — varchar
  • phoneNumber (phone_number) — varchar
  • role — varchar
  • profileImage (profile_image) — varchar

MemberFavorSubs (member_favor_subs)

  • mfsId (mfs_id) — Long — 기본 키 — NOT NULL
  • memberId (member_id) — Long — 외래 키 → Member.memberId — NOT NULL
  • subsId (subs_id) — Long — 외래 키 → Subs.subsId — NOT NULL

MemberHaveSubs (member_have_subs)

  • mhsId (mhs_id) — Long — 기본 키 — NOT NULL
  • memberId (member_id) — Long — 외래 키 → Member.memberId — NOT NULL
  • subsId (subs_id) — Long — 외래 키 → Subs.subsId — NOT NULL
  • rankLevel (rank_level) — varchar

MemberRelTag (member_rel_tag)

  • mrtId (mrt_id) — Long — 기본 키 — NOT NULL
  • memberId (member_id) — Long — 외래 키 → Member.memberId — NOT NULL
  • tagId (tag_id) — Long — 외래 키 → Tag.tagId — NOT NULL
  • tagSort (tag_sort) — Integer
  • haveCnt (have_cnt) — Integer
  • favorCnt (favor_cnt) — Integer
  • isBasic (is_basic) — boolean

MemberSecurity (member_security)

  • securityId (security_id) — Long — 기본 키 — NOT NULL
  • loginId (login_id) — varchar
  • refreshToken (refresh_token) — varchar

Review (review)

  • reviewId (review_id) — Long — 기본 키 — NOT NULL
  • memberId (member_id) — Long — 외래 키 → Member.memberId — NOT NULL
  • content — varchar
  • subsId (subs_id) — Long — 외래 키 → Subs.subsId — NOT NULL
  • rating — Integer
  • createdTime (created_time) — DateTime
  • updatedTime (update_time) — DateTime

Subs (subs)

  • subsId (subs_id) — Long — 기본 키 — NOT NULL
  • subName (subs_name) — varchar
  • categoryId (category_id) — Long — 외래 키 → Category.categoryId — NOT NULL
  • imnfo (info) — varchar
  • recommendSort (recommend_sort) — Integer
  • ratingAvg (rating_avg) — Integer
  • image — varchar

SubsContent (subs_rank_content)

  • contentId (content_id) — Long — 기본 키 — NOT NULL
  • rankId (rank_id) — Long — 외래 키 → SubsRank.rankId — NOT NULL
  • subsId (subs_id) — Long — 외래 키 → SubsRank.subsId — NOT NULL
  • content — varchar

SubsRank (subs_rank)

  • rankId (rank_id) — Long — 기본 키 — NOT NULL
  • subsId (subs_id) — Long — 외래 키 → Subs.subsId — NOT NULL
  • rankName (rank_name) — varchar
  • price — int
  • rankLevel (rank_level) — varchar

SubsRelTag (subs_rel_tag)

  • srtId (srt_id) — Long — 기본 키 — NOT NULL
  • subsId (subs_id) — Long — 외래 키 → Subs.subsId — NOT NULL
  • tagId (tag_id) — Long — 외래 키 → Tag.tagId — NOT NULL

Tag (tag)

  • tagId (tag_id) — Long — 기본 키 — NOT NULL
  • tagName (tag_name) — varchar