ShinhanCard

Tables (11)

Assignee (답변 담당정보)

  • assignee_id (담당정보ID) — Primary key — NOT NULL
  • isChecked (확인여부)
  • inquiry_id (문의ID) — Foreign key → Inquiry.inquiry_id — NOT NULL
  • member_id (사용자ID) — Foreign key → Member.member_id — NOT NULL

Division (본부)

  • division_id (본부ID) — Primary key — NOT NULL
  • name (이름)
  • group_id (그룹ID) — Foreign key → Group.group_id — NOT NULL

FollowUp (추가문의)

  • follow_up_id (추가문의ID) — Primary key — NOT NULL
  • content (내용)
  • created_at (생성일시)
  • member_id (사용자ID) — Foreign key → Member.member_id — NOT NULL
  • inquiry_id (문의ID2) — Foreign key → Inquiry.inquiry_id — NOT NULL

Group (그룹)

  • group_id (그룹ID) — Primary key — NOT NULL
  • name (그룹이름)

Inquiry (문의)

  • inquiry_id (문의ID) — Primary key — NOT NULL
  • title (제목)
  • content (내용)
  • created_at (문의일시)
  • state (상태)
  • author_id (작성자ID) — Foreign key → Member.member_id — NOT NULL

Member (사용자)

  • member_id (사용자ID) — Primary key — NOT NULL
  • name (이름)
  • email (이메일)
  • phone_number (전화번호)
  • profile_image (프로필이미지url)

Refernce (문의참조)

  • reference_id (문의참조ID) — Primary key — NOT NULL
  • inquiry_id (문의ID) — Foreign key → Inquiry.inquiry_id — NOT NULL
  • member_id (사용자ID) — Foreign key → Member.member_id — NOT NULL

Reply (답변)

  • reply_id (답변ID) — Primary key — NOT NULL
  • content (내용)
  • is_accepted (채택여부)
  • inquiry_id (문의ID) — Foreign key → Inquiry.inquiry_id — NOT NULL
  • author_id (답변담당자ID) — Foreign key → Member.member_id — NOT NULL

Scrap (스크랩)

  • Key — Primary key — NOT NULL
  • member_id (사용자ID) — Foreign key → Member.member_id — NOT NULL
  • inquiry_id (문의ID) — Foreign key → Inquiry.inquiry_id — NOT NULL

Team (팀)

  • team_id (팀ID) — Primary key — NOT NULL
  • name (이름)
  • Field2
  • division_id (본부ID) — Foreign key → Division.division_id — NOT NULL

TeamMember (소속)

  • team_member_id (소속ID) — Primary key — NOT NULL
  • is_current (현재소속여부)
  • start_date (소속시작일)
  • end_date (소속종료일)
  • member_id (사용자ID) — Foreign key → Member.member_id — NOT NULL
  • team_id (팀ID) — Foreign key → Team.team_id — NOT NULL