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