super database

Tables (6)

chat (채팅)

  • chatId (채팅 식별자) — binary(27) — Primary key — NOT NULL
  • inquiryId (문의 식별자) — binary(27) — Foreign key → inquiry.inquiryId — NOT NULL
  • hospital_chat_member_ids (병원 채팅 멤버 아이디) — json
  • member_chat_member_id (회원 채팅 맴버 아이디) — binary(27)
  • created_at (생성일시) — datetime
  • updated_at (변경일시) — datetime

chatMember (채팅멤버)

  • chatMemberId (채팅멤버 식별자) — binary(27) — Primary key — NOT NULL
  • member_id (회원 식별자) — bigint
  • hospital_id (병원 식별자) — bigint
  • created_at (생성일시) — datetime
  • updated_at (Field) — datetime

domain_event (도메인 이벤트)

  • domain_event_id (도메인 이벤트 식별자) — bigint — Primary key — NOT NULL
  • event_name (Field) — varchar(100)
  • aggregate_name (Field2)

inquiry (문의)

  • inquiryId (문의 식별자) — binary(27) — Primary key — NOT NULL
  • version (버전) — int
  • consultation_id (consultation 식별자) — bigint
  • hospital_id (병원 식별자) — bigint
  • member_id (회원 식별자) — bigint
  • first_reservation_confirmation_occured_at (처음 예약이 확정되었을때 시점) — datetime
  • created_at (생성일시) — datetime
  • updated_at (변경일시) — datetime

invoice (구매)

  • invoiceId (구매 아이디) — binary(27) — Primary key — NOT NULL
  • version (버전) — int
  • member_id (회원 식별자) — bigint
  • status (상태) — varchar(20)
  • created_at (생성일시) — datetime
  • updated_at (변경일시) — datetime

invoice_line (Untitled)

  • Key — Primary key — NOT NULL
  • Field