mate

Tables (6)

Carpool (Untitled2)

  • PK (CarpoolPk) — Primary key — NOT NULL
  • 드라이버 (memberPk) — Foreign key → Member.PK — NOT NULL
  • 출발지 (departureArea) — varchar
  • 탑승장소(상세) (Field2) — varchar
  • 출발시간 (departureTime) — DateTime
  • 채팅방링크 (chatLink) — varchar
  • 탑승인원 (capacity) — int
  • 탑승비용 (cost) — int

Driver (Untitled6)

  • DriverPK — Primary key — NOT NULL
  • PK (memberPk) — bigint — Foreign key → Member.PK — NOT NULL
  • 차량번호 (carNumber) — varchar
  • 전화번호 (phoneNumber) — varchar
  • 차량이미지 (carImage) — varchar
  • 등록날짜 (Field)

Member (Untitled)

  • PK (memberPk) — bigint — Primary key — NOT NULL
  • 아이디 (memberId) — varchar
  • 닉네임 (nickname) — varchar
  • 이메일 (email) — varchar
  • 비밀번호 (password) — varchar
  • 가입경로 (providerType) — varchar
  • 역할(Role) (memberType) — varchar
  • 예약여부 (reservation) — bigint
  • 프로필이미지 (image) — varchar
  • 드라이버여부 (isDriver) — boolean

Report (Untitled3)

  • PK (ReportPk) — Primary key — NOT NULL
  • PK (memberPk) — Foreign key → Member.PK — NOT NULL
  • PK (CarpoolPk) — Foreign key → Carpool.PK — NOT NULL
  • 신고제목 (reportTitle) — varchar
  • 신고내용 (reportContent) — varchar

Reservation (Untitled5)

  • Key — Primary key — NOT NULL
  • PK (CarpoolPk) — Foreign key → Carpool.PK — NOT NULL
  • PK (memberPk) — Foreign key → Member.PK — NOT NULL

TimeStamped (Untitled4)

  • 생성날짜 (createAt)
  • 수정날짜 (updateAt)
  • 삭제날짜(soft_delete) (deleteAt)
  • 삭제여부 (isDelete) — Boolean