shinhancard

Tables (15)

Attached_files (파일)

  • id (Key) — Primary key — NOT NULL
  • file_name (파일명)
  • file_url (파일url)
  • id (문의아이디) — Foreign key → Inquiry.id — NOT NULL

BaseEntity (Untitled3)

  • created_at (생성시간)
  • modified_at (수정시간)
  • is_deleted (삭제/취소 여부)

Comments (답변)

  • id (Key) — Primary key — NOT NULL
  • inquiry_id (문의아이디) — Foreign key → Inquiry.id — NOT NULL
  • is_accepted (채택여부) — boolean
  • content (내용)
  • id (답변담당자 id) — Foreign key → Inquiry_assignees.id — NOT NULL
  • user_id (유저아이다) — Foreign key → User.id — NOT NULL
  • accepted_at (채택일시)
  • parent_id (상위댓글id) — Foreign key → Comments.id — NOT NULL

Divisions (본부)

  • id (본부아이디) — Primary key — NOT NULL
  • id (그룹아이디) — Foreign key → Groups.id — NOT NULL
  • name (본부명)

Email_logs (이메일히스토리)

  • id (Key) — Primary key — NOT NULL
  • inquiry_id (Field)
  • Field2
  • inquiry_id (문의아이디) — Foreign key → Inquiry.id — NOT NULL
  • user_id (유저아이디) — Foreign key → User.id — NOT NULL

FollowUp (추가문의)

  • Key — Primary key — NOT NULL
  • id (문의아이디) — Foreign key → Inquiry.id — NOT NULL
  • id (아이디2) — Foreign key → User.id — NOT NULL
  • content (문의내용)

Groups (그룹)

  • id (아이디) — Primary key — NOT NULL
  • name (그룹병)

Inquiry (문의)

  • id (문의아이디) — Primary key — NOT NULL
  • id (유저id) — Foreign key → User.id — NOT NULL
  • id (팀아이디) — Foreign key → Team.id — NOT NULL
  • title (문의제목)
  • content (문의내용)
  • status (문의상태) — ENUM
  • id_deleted (삭제여부)
  • Field (파일url)
  • isDraft (Field)
  • id (팀아이디2) — Foreign key → Team.id — NOT NULL

Inquiry_assignees (답변담당자)

  • id (Key) — Primary key — NOT NULL
  • inquiry_id (문의아이디) — Foreign key → Inquiry.id — NOT NULL
  • id (유저id) — Foreign key → User.id — NOT NULL
  • is_read (확인여부)

Inquiry_observers (답변참조자)

  • id (아이디) — Primary key — NOT NULL
  • inquiry_id (문의id) — Foreign key → Inquiry.id — NOT NULL
  • user_id (유저id) — Foreign key → User.id — NOT NULL

Interested_member (관심팀원)

  • id (아이디) — Primary key — NOT NULL
  • user_id (유저id) — Foreign key → User.id — NOT NULL
  • interested_user_id (관심대상 유저 id) — Foreign key → User.id — NOT NULL

Scrap (스크랩)

  • id (Key) — Primary key — NOT NULL
  • user_id (유저아이디) — Foreign key → User.id — NOT NULL
  • inqury_id (문의아이디) — Foreign key → Inquiry.id — NOT NULL

Team (팀)

  • id (팀아이디) — Primary key — NOT NULL
  • id (본부아이디) — Foreign key → Divisions.id — NOT NULL
  • name (팀명)

TeamUser (Untitled5)

  • id (아이디) — Primary key — NOT NULL
  • user_id (유저아이디) — Foreign key → User.id — NOT NULL
  • team_id (팀아이디) — Foreign key → Team.id — NOT NULL
  • is_existed (팀탈퇴여부) — boolean
  • role (역할) — ROLE("TEAM_LEADER", "TEAM_MEMBER")
  • joinedAt (Field)
  • leftAt (Field2)

User (유저)

  • id (아이디) — Primary key — NOT NULL
  • password (비밀번호)
  • employee_id (사번)
  • name (이름)
  • email (이메일)
  • phone_number (전화번호)
  • image_url (프로필이미지url)