ShinhanCard

Tables (13)

Answer (답변)

  • AnswerId (answer_id) — BIGINT — Primary key — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
  • inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
  • content (Field) — TEXT
  • createdAt (created_at) — DATETIME
  • isAdopted (is_adopted) — BOOLEAN

AnswerAssignee (답변담당자)

  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
  • inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
  • assignedAt (assigned_at)
  • lastEnterdAt (last_entered_at) — DATETIME
  • notifiedAt (notified_at) — DATETIME

EmailLog (메일 로깅)

  • logId (email_log_id) — BIGINT — Primary key — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
  • inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
  • AnswerId (answer_id) — BIGINT — Foreign key → Answer.AnswerId — NOT NULL
  • sentAt (sent_at) — DATETIME
  • status (Field2) — ENUM
  • errorMessage (error_message) — BIGINT

FollowUp (추가 문의)

  • followUpId (followUp_id) — BIGINT — Primary key — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
  • inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
  • content (Field) — TEXT
  • createdAt (create_at) — DATETIME

Headquarter (본부)

  • headquarterId (headquarter_id) — BIGINT — Primary key — NOT NULL
  • groupId (group_id) — BIGINT — Foreign key → OrgGroup.groupId — NOT NULL
  • Field

Inquiry (문의)

  • inquiryId (inquiry_id) — BIGINT — Primary key — NOT NULL
  • content (Field) — TEXT
  • isDraft (is_draft) — BOOLEAN
  • status (Field2) — ENUM
  • createdAt (create_at) — DATETIME
  • updatedAt (updated_at) — DATETIME
  • isDeleted (is_deleted) — BOOLEAN
  • teamId (team_id) — BIGINT — Foreign key → Team.teamId — NOT NULL

InquiryReference (문의참조자)

  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
  • inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL

Notification (알림)

  • notificationId (notification_id) — BIGINT — Primary key — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
  • inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL
  • type (Field) — ENUM
  • content (Field2) — TEXT
  • isRead (is_read) — BOOLEAN
  • lastUpdatedAt (last_updated_at) — DATETIME

OrgGroup (그룹)

  • groupId (group_id) — BIGINT — Primary key — NOT NULL
  • name (Field)

Scrap (스크랩)

  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
  • inquiryId (inquiry_id) — BIGINT — Foreign key → Inquiry.inquiryId — NOT NULL

Team (팀)

  • teamId (team_id) — BIGINT — Primary key — NOT NULL
  • headquarterId (headquarter_id) — BIGINT — Foreign key → Headquarter.headquarterId — NOT NULL
  • status (Field) — ENUM

User (사용자)

  • userId (user_id) — BIGINT — Primary key — NOT NULL
  • userName (user_name) — VARCHAR(100)
  • Field

User-Team (사용자-팀 중간테이블)

  • teamId (team_id) — BIGINT — Foreign key → Team.teamId — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL
  • role (Field) — ENUM
  • joinedAt (joined_at) — DATETIME
  • leftAt (left_at) — DATETIME