gatchi
Tables (14)
POINTHISTORY
- useremail — varchar2(255)
- meetListNum — number
- pointUseHistory — varchar2(1000)
- useTime — DATE
- usepoint — NUMBER
- usetype — number
- afterpoint — NUMBER
- beforpoint — number
USERPOINT
- email — VARCHAR2(255)
- pointBalance — NUMBER(10)
challenge
- challengeListNum — number
- challengeTitle — varchar2(1000)
- challengeImageMain — varchar2(4000)
- challengeWeekCheck — varchar2(1000)
- challengeDateCheck — varchar2(1000)
- challengeStartDate — date
- challengeEndDate — date
- challengeImageSuccess — varchar2(4000)
- challengeImageFail — varchar2(4000)
- challengeLikeCount — number
- challengeContent — varchar2(4000)
- challengeMemberCount — number
- challengeCreateDate — Date
- challengeStatus — number
- challengeChatRoomNum — varchar2(1000)
challengeAuth
- challengeListNum — number
- challengeAuthListNum — number
- email — varchar2(1000)
- challengeAuthContent — varchar2(4000)
- challengeAuthCreateDate — Date
- challengeAuthImage — varchar2(4000)
- challengeAuthStatus — number
challengeinfo
- challengeListNum — number
- email — varchar2(1000)
- challengeMemberStatus — number
challengelike
- challengeListNum — number
- userEmail — varchar2(1000)
customerCenter
- centerSubject — VARCHAR2(50)
- centerQuestion — VARCHAR2(1000)
- centerAnswer — VARCHAR2(1000)
gatchi
- 고유번호 (meetListNum) — number
- 무슨미트? (meetCheck) — number
- meetCtgNum — number
- meetName — varchar2(500)
- meetTitle — varchar2(500)
- meetContent — varchar2(4000)
- meetImage — varchar2(1000)
- meetDate — date
- meetDday — varchar2(1000)
- meetMemCnt — number
- meetMaxMemCnt — number
- meetHitCount — number
- meetLikeCount — number
- meetHow — number
- meetEntryFee — number
- meetMoney — number
- meetPlace — varchar2(1000)
- meetStatus — number
- chatRoomNum — varchar2(1000)
- code — number
gatchiLike
- meetListNum — number
- userEmail — varchar2(20)
latlng
- lat — number
- lng — number
- meetListNum — number
meetCategory
- 고유번호 (meetListNum) — Number — Primary key — NOT NULL
- 카테고리명 (meetCtgName) — varchar2
meetInfo
- meetListNum — number
- email — varchar2(100)
- meetMemStatus — number
- approvalStatus — number
meetReview
- meetListNum — number
- meetReviewNum — number
- email — varchar2(100)
- meetReviewContent — varchar2(4000)
- meetReviewDate — date
- meetReviewImg — varchar2(1000)
paymentInfo
- email — varchar2(1000)
- paid_amount — number
- paid_at — varchar2(1000)
- pay_method — varchar2(30)
- card_name — varchar2(50)
- card_number — varchar2(50)
- apply_num — varchar2(30)
- name — varchar2(50)
- status — varchar2(20)