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