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)