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