catPunch

테이블 (15)

FAQ (cat_faq)

  • Key (cf_id) — int — 기본 키 — NOT NULL
  • Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
  • Field (faq_title) — varchar(50) — NOT NULL
  • Field (faq_text) — varchar(2000) — NOT NULL
  • Field2 (faq_writedate) — datetime — NOT NULL
  • Field3 (faq_update) — datetime
  • Field4 (faq_deletedate) — datetime
  • Field5 (faq_show) — tinyint(1) — NOT NULL
  • Field6 (faq_writer) — varchar(50) — NOT NULL

결제내역 테이블 (cat_payment)

  • Key (cp_id) — int — 기본 키 — NOT NULL
  • Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
  • Field (fk_cpid) — int — NOT NULL
  • Field (pay_sort_1) — int
  • Field2 (pay_sort_2) — int
  • Field3 (pay_sort_3) — int
  • Field4 (pay_amount) — int
  • Field5 (pay_date) — datetime

공지사항 (cat_info)

  • Key (ci_id) — int — 기본 키 — NOT NULL
  • Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
  • Field (info_image) — varchar(50)
  • Field2 (info_title) — varchar(50) — NOT NULL
  • Field3 (info_text) — varchar(2000) — NOT NULL
  • Field4 (info_writedate) — datetime — NOT NULL
  • Field5 (info_update) — datetime
  • Field (info_deletedate) — datetime
  • Field (info_show) — tinyint(1) — NOT NULL
  • Field2 (info_notice) — tinyint(1) — NOT NULL
  • Field3 (info_viewcount) — int — NOT NULL
  • Field4 (info_writer) — varchar(50) — NOT NULL
  • Field5 (info_filepath) — varchar(100)
  • Field6 (int_imageUrl) — varchar(500)
  • Field7 (int_imageName) — varchar(500)

공지사항 댓글 (info_comment)

  • Key (ic_id) — int — 기본 키 — NOT NULL
  • Key (ci_id) — int — 외래 키 → 공지사항.Key — NOT NULL
  • Key (u_id) — int — 외래 키 → 공지사항.Key — NOT NULL
  • Field (fk_icid) — int — NOT NULL
  • Field (icomment_text) — varchar(2000) — NOT NULL
  • Field (icomment_writer) — varchar(20) — NOT NULL
  • Field (icomment_writedate) — datetime — NOT NULL
  • Field (icomment__update) — datetime
  • Field (icomment_deletedate) — datetime
  • Field (icomment_show) — tinyint(1) — NOT NULL

보호 고양이 목록 (cat_list)

  • Key (c_id) — int — 기본 키 — NOT NULL
  • Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
  • Field (cat_adopt) — tinyint(1) — NOT NULL
  • Field2 (cat_support) — tinyint(1) — NOT NULL
  • Field3 (cat_age) — int — NOT NULL
  • Field4 (cat_gender) — tinyint(1) — NOT NULL
  • Field5 (cat_name) — varchar(20) — NOT NULL
  • Field6 (cat_color) — varchar(20) — NOT NULL
  • Field7 (cat_breed) — varchar(20) — NOT NULL
  • Field8 (cat_supportok) — tinyint(1) — NOT NULL
  • Field (cat_show) — tinyint(1) — NOT NULL

신랑신부찾기 (cat_marriage)

  • Key (cm_id) — int — 기본 키 — NOT NULL
  • Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
  • Field (marriage_title) — varchar(50) — NOT NULL
  • Field (marriage_writer) — varchar(20) — NOT NULL
  • Field (marriage_text) — varchar(2000) — NOT NULL
  • Field2 (marriage_area) — varchar(2) — NOT NULL
  • Field3 (marriage_writedate) — datetime — NOT NULL
  • Field4 (marriage_update) — datetime
  • Field5 (marriage_deletedate) — datetime
  • Field (marriage_show) — tinyint(1) — NOT NULL
  • Field2 (marriage_viewcount) — int — NOT NULL
  • Field3 (marriage_imageUrl) — varchar(500)
  • Field (marriage_imageName) — varchar(500)

신랑신부찾기 댓글 (marriage_comment)

  • Key (mc_id) — int — 기본 키 — NOT NULL
  • Key (cm_id) — int — 외래 키 → 신랑신부찾기.Key — NOT NULL
  • Key (u_id) — int — 외래 키 → 신랑신부찾기.Key — NOT NULL
  • Field (fk_mcid) — int — NOT NULL
  • Field (mcomment_text) — varchar(2000) — NOT NULL
  • Field (mcomment_write) — varchar(20) — NOT NULL
  • Field (mcomment_writedate) — datetime — NOT NULL
  • Field (mcomment_show) — tinyint(1) — NOT NULL

유저 정보 (cat_user)

  • Key (u_id) — int — 기본 키 — NOT NULL
  • Field (user_id) — varchar(20) — NOT NULL
  • Field (user_password) — varchar(60) — NOT NULL
  • Field (user_names) — varchar(20) — NOT NULL
  • Field (user_tel) — varchar(20) — NOT NULL
  • Field (user_email) — varchar(50) — NOT NULL
  • Field (user_zipcode) — varchar(50) — NOT NULL
  • Field (user_streetAddr) — varchar(50) — NOT NULL
  • Field (user_detailedAddr) — varchar(50) — NOT NULL
  • Field (user_role) — varchar(20) — NOT NULL
  • Field (user_joindate) — datetime — NOT NULL
  • Field (user_show) — tinyint(1) — NOT NULL

일시결제, 정기결제 1회차 (tiesponsorshipvo)

  • Key (pay_aid) — varchar(50) — 기본 키 — NOT NULL
  • Key (pay_userid) — varchar(100) — 외래 키 → 유저 정보.Key — NOT NULL
  • Field (pay_tid) — varchar(50)
  • Field (pay_cid) — varchar(50)
  • Field2 (pay_sid) — varchar(50)
  • Field3 (pay_amount) — varchar(50)
  • Field4 (pay_cardinfo) — varchar(50)
  • Field5 (pay_itemname) — varchar(50)
  • Field (pay_quantity) — int
  • Field2 (pay_taxfreeamount) — int
  • Field3 (pay_createdate) — date
  • Field4 (pay_approvedate) — date
  • Field (pay_catname) — varchar(20)
  • Field2 (pay_onesorregural) — tinyint(1)
  • Field3 (pay_counting) — int

입양 결연 테이블 (cat_adopt)

  • Key (ca_id) — int — 기본 키 — NOT NULL
  • Key (fk_caid) — int — 기본 키 — NOT NULL
  • Key (c_id) — int — 외래 키 → 보호 고양이 목록.Key — NOT NULL
  • Key (u_id) — int — 외래 키 → 보호 고양이 목록.Key — NOT NULL
  • Field1 (adopt_imageName) — varchar(500)
  • Field2 (adopt_imageUrl) — varchar(500)
  • Field (catadopt_text) — varchar(2000) — NOT NULL
  • Field2 (catadopt_writedate) — datetime
  • Field3 (catadopt_update) — datetime
  • Field4 (catadopt_deletedate) — datetime
  • Field5 (catadopt_show) — tinyint(1) — NOT NULL

입양 후기 (adopt_review)

  • Key (r_id) — int — 기본 키 — NOT NULL
  • Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
  • Field (review_image) — varchar(50) — 리뷰 이미지
  • Field (review_title) — varchar(50) — NOT NULL
  • Field2 (review_writer) — varchar(20) — NOT NULL
  • Field3 (review_text) — varchar(2000) — NOT NULL
  • Field4 (review_writedate) — datetime — DEFAULT_GENERATED
  • Field5 (review_update) — datetime
  • Field6 (review_deletedate) — datetime
  • Field7 (review_show) — tinyint(1) — NOT NULL
  • Field (review_notice) — tinyint(1) — NOT NULL
  • Field2 (review_viewcount) — int — NOT NULL
  • Field3 (review_imageUrl) — varchar(500)
  • Field (review_imageName) — varchar(500)

입양 후기 댓글 (review_comment)

  • Key (rc_id) — int — 기본 키 — NOT NULL
  • Key (r_id) — int — 외래 키 → 입양 후기.Key — NOT NULL
  • Key (u_id) — int — 외래 키 → 입양 후기.Key — NOT NULL
  • Field (fk_rcid) — int — NOT NULL
  • Field (rcomment_text) — varchar(2000) — NOT NULL
  • Field (rcomment_writer) — varchar(20) — NOT NULL
  • Field (rcomment_writerdate) — datetime — NOT NULL
  • Field (rcomment_update) — datetime
  • Field (rcomment_deletedate) — datetime
  • Field (rcomment_show) — tinyint(1) — NOT NULL

정기결제 2회차 이상 (supportreguralinfo)

  • Key (pay_sid) — varchar(100) — 기본 키 — NOT NULL
  • Key (pay_aid) — varchar(50) — 외래 키 → 일시결제, 정기결제 1회차.Key — NOT NULL
  • Key (pay_userid) — varchar(100) — 외래 키 → 유저 정보.Key — NOT NULL
  • Field2 (pay_amount) — varchar(100)
  • Field3 (pay_cardinfo) — varchar(100)
  • Field4 (pay_itemname) — varchar(100)
  • Field (pay_catname) — varchar(100)
  • Field3 (pay_counting) — int
  • Field (pay_paydate) — date
  • Field2 (pay_approvedate) — date

쪽지보내기 (cat_msg)

  • Key (msg_id) — int — 기본 키 — NOT NULL
  • Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
  • Field (send_id) — vatchar(50) — NOT NULL
  • Field (receive_id) — vatchar(50) — NOT NULL
  • Field (content) — vatchar(1000)
  • Field (write_date) — datetime
  • Field2 (read_yn) — tinyint(1)

활동내역 (support_event)

  • Field (se_id) — int — 기본 키 — NOT NULL
  • Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
  • Field (event_title) — NOT NULL
  • Field (event_text)
  • Field (event_writedate)
  • Field (event_update)
  • Field (event_deletedate)
  • Field (event_show)
  • Field (event_viewcount)
  • Field (event_imageUrl)
  • Field (event_imageName)