꾸독
테이블 (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