WithPlacePrototype

테이블 (6)

매칭 요청 (MatchingRequest)

  • Key (matchingReqestSeq) — int — 기본 키 — NOT NULL
  • 매칭 타입 (matchingType) — varchar
  • Field (preference) — varchar
  • Field2 (status) — varchar
  • Field (state) — varchar
  • Field (city) — varchar
  • Field (town) — varchar
  • Field (regBy) — varchar
  • Field (regDate) — date
  • Field2 (uptBy) — varchar
  • Field (uptDate) — date

매칭 정보 (MatchedInfo)

  • Key (matchedInfoSeq) — int — 기본 키 — NOT NULL
  • Key (placeSeq) — int — 외래 키 → 장소정보.Key — NOT NULL
  • Field (status) — varchar
  • Field (meetingDate) — date
  • Field (meetingTime) — date
  • Field (regBy) — varchar
  • Field (regDate) — date
  • Field (uptBy) — varchar
  • Field (uptDate) — date

사용자 매칭 요청 리스트 (UserMatchingRequest)

  • Key (userMatchingRequestSeq) — int — 기본 키 — NOT NULL
  • Key (userSeq) — int — 외래 키 → 사용자 정보.Key — NOT NULL
  • Key (matchingReqestSeq) — int — 외래 키 → 매칭 요청.Key — NOT NULL

사용자 매칭 정보 (UserMatchedInfo)

  • Key (userMatchedInfoSeq) — int — 기본 키 — NOT NULL
  • seq (userSeq) — int — 외래 키 → 사용자 정보.Key — NOT NULL
  • Key (matchedInfoSeq) — int — 외래 키 → 매칭 정보.Key — NOT NULL

사용자 정보 (User)

  • Key (userSeq) — int — 기본 키 — NOT NULL
  • Field (userId) — varchar
  • Field (userPw) — varchar
  • Field (userName) — varchar
  • Field (age) — int
  • Field2 (gender) — varchar
  • Field (state) — varchar
  • Field (city) — varchar
  • Field (town) — varchar
  • Field (regBy) — varchar
  • Field (regDate) — date
  • Field (uptBy) — varchar
  • Field (uptDate) — varchar

장소정보 (Place)

  • Key (placeSeq) — int — 기본 키 — NOT NULL
  • Field (addressName) — varchar
  • Field (categoryGroupCode) — varchar
  • Field (categoryGroupName) — varchar
  • Field (categoryName) — varchar
  • Field (distance) — varchar
  • Field (id) — varchar
  • Field (phone) — varchar
  • Field (placeName) — varchar
  • Field (placeUrl) — varchar
  • Field (roadAddressName) — varchar
  • Field (x) — varchar
  • Field (y) — varchar
  • Field (regBy) — varchar
  • Field (regDate) — date
  • Field (uptBy) — varchar
  • Field (uptDate) — date