골프는 장비빨

테이블 (22)

Addresses

  • id (addressID) — Int — 기본 키 — NOT NULL
  • clubSaleID — Int — 외래 키 → ClubSales.id — NOT NULL
  • fullAdressInJibunFormat — String — NOT NULL
  • fullAdressInRoadNameFormat — String
  • fullAddressInEnglish — String — NOT NULL
  • postCode — String
  • siName — String — NOT NULL — 시 명
  • sggName — String — NOT NULL — 시,군,구 명
  • liName — String — NOT NULL — 법,정,리 명
  • roadName — String — NOT NULL — 도로명
  • bunji — String — NOT NULL — 번지
  • ho — String — NOT NULL — 호
  • detail — String — NOT NULL — 상세주소

ClubImageURLs

  • id (clubImageURLsID) — Int — 기본 키 — NOT NULL
  • clubID — Int — 외래 키 → Clubs.id — NOT NULL
  • id (likedClubModels) — Int — 외래 키 → Clubs.likedClubModels — NOT NULL
  • headBottom — String — NOT NULL
  • headTop — String — NOT NULL
  • headFace — String — NOT NULL
  • shaft — String — NOT NULL
  • grip — String — NOT NULL

ClubMakers

  • id (clubMakerID) — Int — 기본 키 — NOT NULL
  • name (clubMakerName) — String — NOT NULL

ClubModelImageURLs

  • id (clubModelImageURLID) — Int — 기본 키 — NOT NULL
  • clubModelID — Int — 외래 키 → ClubModels.id — NOT NULL
  • url (clubModelImageURL) — String — NOT NULL
  • imageType (clubImageType) — Int — NOT NULL — 0: headTop, 1: headBottom 2:headFace, 3: else

ClubModels

  • id (clubModelID) — Int — 기본 키 — NOT NULL
  • clubMakerID — Int — 외래 키 → ClubMakers.id — NOT NULL
  • likedClubModelID (likedClubModels) — Int — 외래 키 → LikedClubModels.id — NOT NULL
  • name (clubModelName) — String — NOT NULL
  • clubType — Int — NOT NULL — 0: Driver 1: Wood 2: Util 3: Iron 4: Wedge 5: Putter
  • gender — Int — NOT NULL — 0: 남여 1: 여 2: 남
  • isOfficial — Bool
  • specs — String
  • headTopImageURL — String
  • headBottomImageURL — String
  • originalPrice — Int
  • secondHandPrice — Int
  • akCode — String

ClubSales

  • id (clubSaleID) — Int — 기본 키 — NOT NULL
  • clubID — Int — 외래 키 → Clubs.id — NOT NULL
  • price — Int
  • description — String
  • status — Int — NOT NULL — 0: 등록됨 1: 예약중 2: 삭제됨 3: 판매완료

ClubSets

  • id (clubSetID) — Int — 기본 키 — NOT NULL
  • userID — Int — 외래 키 → Users.id — NOT NULL

ClubSpecifications

  • id (specificationID) — Int — 기본 키 — NOT NULL
  • clubID — Int — 외래 키 → Clubs.id — NOT NULL
  • id (likedClubModels) — Int — 외래 키 → Clubs.likedClubModels — NOT NULL
  • shaftType — Int — NOT NULL
  • shaftFlexibility (shaftStrength) — Int — NOT NULL — 0: R 1: SR 2: S 3: SX
  • loftAngle (angle) — Int

Clubs

  • id (clubID) — Int — 기본 키 — NOT NULL
  • clubModelID — Int — 외래 키 → ClubModels.id — NOT NULL
  • userID — Int — 외래 키 → Users.id — NOT NULL
  • clubSetID — Int — 외래 키 → ClubSets.id — NOT NULL
  • likedClubModels — Int — 외래 키 → ClubModels.likedClubModelID — NOT NULL
  • status (clubStatus) — Int — NOT NULL — 0: 소유 중 1: 판매 중 2: 예약중
  • condition — Int — NOT NULL — 0: 새재품 1: A급 2: B급 3: C급
  • numbers — Int

DebuggingTransactions

  • id (debuggingTransactionID) — Int — 기본 키 — NOT NULL
  • status — Int — NOT NULL
  • message — Int — NOT NULL
  • clientPlatform — Int — NOT NULL — 0: iOS 1: Android

DeviceProfiles

  • id (deviceProfileID) — Int — 기본 키 — NOT NULL
  • userID — Int — 외래 키 → Users.id — NOT NULL
  • name (deviceName) — String — NOT NULL
  • operatingSystem (deviceOperatingSystem) — Int — NOT NULL — 0: iOS, 1: Android
  • language (deviceLanguage) — Int — NOT NULL — 0:한글, 1:영문, 2:중국어
  • isPushOn — Boolean — NOT NULL
  • fcmToken — String

LikedClubModels

  • id (likedClubModels) — Int — 기본 키 — NOT NULL
  • userID — Int — 외래 키 → Users.id — NOT NULL

NotificationImageURLs

  • id (notificationImageURLID) — Int — 기본 키 — NOT NULL
  • notificationID — Int — 외래 키 → Notifications.id — NOT NULL
  • url (notificationImageURL) — String

Notifications

  • id (notificationID) — Int — 기본 키 — NOT NULL
  • userID — Int — 외래 키 → Users.id — NOT NULL
  • title — String
  • body — String
  • eventType — Int
  • eventValue — Int

PriceUpdateTransactions

  • id (priceDetailID) — Int — 기본 키 — NOT NULL
  • clubModelID — Int — 외래 키 → ClubModels.id — NOT NULL
  • id (likedClubModels) — Int — 외래 키 → ClubModels.likedClubModelID — NOT NULL
  • updatedPrice — Int
  • clubCount — Int

Provinces

  • id (provinceID) — Int — 기본 키 — NOT NULL
  • name (provinceName) — String
  • code (provinceCode) — Int — NOT NULL

PurchaseReservations

  • id (purchaseReservationID) — Int — 기본 키 — NOT NULL
  • clubSaleID — Int — 외래 키 → ClubSales.id — NOT NULL
  • userID — Int — 외래 키 → Users.id — NOT NULL
  • date (reservationDate) — Date
  • status (reservationStatus) — Int — NOT NULL — 0: 예약중 1: 예약취소 2: 거래완료
  • price — Int — NOT NULL

PutterSpecifications

  • id (wedgeSpecificationID) — Int — 기본 키 — NOT NULL
  • clubID — Int — 외래 키 → Clubs.id — NOT NULL
  • id (likedClubModels) — Int — 외래 키 → Clubs.likedClubModels — NOT NULL
  • headType — Int — NOT NULL — 0: 일자형 1: 반달형
  • shaftLength — Int — NOT NULL

Regions

  • id (regionID) — Int — 기본 키 — NOT NULL
  • userID — Int — 외래 키 → Users.id — NOT NULL
  • provinceName — String — NOT NULL
  • provinceCode — Int — NOT NULL
  • suburbName — String — NOT NULL
  • suburbCode — Int — NOT NULL

ReservationUsers

  • id (reservationUserID) — Int — 기본 키 — NOT NULL
  • userID — Int — 외래 키 → Users.id — NOT NULL
  • purchaseReservationID — Int — 외래 키 → PurchaseReservations.id — NOT NULL
  • type (userType) — Int — NOT NULL — 0: 판매자 (seller) 1: 구매자(buyer)

Suburbs

  • id (suburbID) — Int — 기본 키 — NOT NULL
  • provinceID — Int — 외래 키 → Provinces.id — NOT NULL
  • name (suburbName) — String
  • code (suburbCode) — Int — NOT NULL

Users

  • id (userID) — Int — 기본 키 — NOT NULL
  • clientSecretKey — String
  • phoneNumber — String — NOT NULL
  • password — String — NOT NULL
  • nickname — String — NOT NULL
  • profileImageURL — String