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