골프는 장비빨
테이블 (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