hopedog table

Tables (34)

TBL_ADMIN

  • ADMIN_NO — NUMBER — Primary key — NOT NULL
  • ADMIN_ID — VARCHER2(100) — NOT NULL
  • ADMIN_PASSWORD — VARCHAR2(100) — NOT NULL

TBL_ADOPT

  • ADOPT_NO — NUMBER — Primary key — NOT NULL
  • CENTER_MEMBER_NO — NUMBER — Foreign key → TBL_CENTERMEMBER.CENTER_MEMBER_NO — NOT NULL
  • ADOPT_PERIODSTART — DATE — NOT NULL
  • ADOPT_PERIOEND — DATE — NOT NULL
  • ADOPT_BREAD — VARCHAR2(1000) — NOT NULL
  • ADOPT_NEUTERING — CHAR(1) — NOT NULL
  • ADOPT_GENDER — CHAR(1) — NOT NULL
  • ADOPT_WEIGHT — VARCHAR2(1000) — NOT NULL
  • ADOPT_BIRTH — DATE — NOT NULL
  • ADOPT_INTRODUCE — VARCHAR2(1000) — NOT NULL
  • ADOPT_TITLE — VARCHAR2(1000) — NOT NULL
  • ADOPT_CONTENT — VARCHAR2(1000) — NOT NULL
  • ADOPT_REGIDATE — DATE — NOT NULL
  • ADOPT_UPDATEDATE — DATE

TBL_ADOPT_COMMENT

  • ADOPT_COMMENT_NO — NUMBER — Primary key — NOT NULL
  • ADOPT_NO — NUMBER — Foreign key → TBL_ADOPT.ADOPT_NO — NOT NULL
  • ADOPT_COMMENT — VARCHAR2(100) — NOT NULL
  • ADOPT_COMMENT_REGIDATE — DATE — NOT NULL
  • ADOPT_COMMENT_WRITER — NUMBER — NOT NULL
  • ADOPT_COMMENT_UPDATEDATE — DATE

TBL_ADOPT_FILE

  • FILE_NO — NUMBER — Primary key — NOT NULL
  • ADOPT_NO — NUMBER — Foreign key → TBL_ADOPT.ADOPT_NO — NOT NULL
  • FILE_NAME — VARCHAR2(1000) — NOT NULL
  • STORED_FILE_NAME — VARCHAR2(1000) — NOT NULL
  • FILE_UUID — VARCHAR2(1000) — NOT NULL
  • FILE_PATH — NUMBER — NOT NULL
  • UPLOAD_TIME — DATE — NOT NULL

TBL_ADOPT_REQUEST

  • PROTECT_REQUEST_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → TBL_MEMBER.MEMBER_NO — NOT NULL
  • CENTER_MEMBER_NO — NUMBER — Foreign key → TBL_CENTERMEMBER.CENTER_MEMBER_NO — NOT NULL
  • ADOPT_NO — NUMBER — Foreign key → TBL_ADOPT.ADOPT_NO — NOT NULL
  • PROTECT_REQUEST_NAME — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_PHONE — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_PHONE_SUB — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_EMAIL — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_GENDER — CHAR(1) — NOT NULL
  • ADOPT_REQUEST_AGE — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_ZIPCODE — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_ADDRESS — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_ADDRESS_DETAIL — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_JOB — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_MARRY — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_INFO_AGREEMENT — CHAR(1) — NOT NULL
  • ADOPT_REQUEST_Q1 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q2 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q3 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q4 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q5 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q6 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q7 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q8 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q9 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q10 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q11 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q12 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q13 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q14 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_Q15 — VARCHAR2(1000) — NOT NULL
  • ADOPT_REQUEST_ADOPT_AGREEMENT — CHAR(1) — NOT NULL

TBL_CAR

  • CAR_NO — NUMBER — Primary key — NOT NULL
  • CAR_CATE — VARCHAR2(1000) — NOT NULL
  • CAR_TITLE — VARCHAR2(1000) — NOT NULL
  • CAR_CONTENT — VARCHAR2(1000) — NOT NULL
  • CAR_REGIDATE — DATE — NOT NULL
  • CAR_UPDATEDATE — DATE
  • CAR_WRITER — NUMBER — NOT NULL

TBL_CAR_COMMENT

  • CAR_COMMENT_NO — NUMBER — Primary key — NOT NULL
  • CAR_NO — NUMBER — Foreign key → TBL_CAR.CAR_NO — NOT NULL
  • CAR_COMMENT — VARCHAR2(1000) — NOT NULL
  • CAR_COMMENT_REGIDATE — DATE — NOT NULL
  • CAR_UPDATEDATE — DATE
  • CAR_COMMENT_WRITER — NUMBER — NOT NULL

TBL_CAR_FILE

  • FILE_NO — NUMBER — Primary key — NOT NULL
  • CAR_NO — NUMBER — Foreign key → TBL_CAR.CAR_NO — NOT NULL
  • FILE_NAME — VARCHAR2(1000) — NOT NULL
  • STORED_FILE_NAME — VARCHAR2(1000) — NOT NULL
  • FILE_UUID — VARCHAR2(1000) — NOT NULL
  • FILE_PATH — NUMBER — NOT NULL
  • UPLOAD_TIME — DATE — NOT NULL

TBL_CENTERMEMBER

  • CENTER_MEMBER_NO — NUMBER — Primary key — NOT NULL
  • CENTER_MEMBER_ID — VARCHAR2(1000) — NOT NULL
  • CENTER_MEMBER_PASSWORD — VARCHAR2(1000) — NOT NULL
  • CENTER_MEMBER_NAME — VARCHAR2(1000) — NOT NULL
  • CENTER_MEMBER_EMAIL — VARCHAR2(1000) — NOT NULL
  • CENTER_MEMBER_ZIPCODE — VARCHAR2(1000) — NOT NULL
  • CENTER_MEMBER_ADDRESS — VARCHAR2(1000) — NOT NULL
  • CENTER_MEMBER__DETAIL_ADDRESS — VARCHAR2(1000) — NOT NULL
  • CENTER_MEMBER_PHONE — VARCHAR2(1000) — NOT NULL
  • Field (CENTER_MEMBER_AGREE) — CHAR(1) — NOT NULL

TBL_CENTER_FILE

  • FILE_NO — NUMBER — Primary key — NOT NULL
  • CENTER_MEMBER_NO — NUMBER — Foreign key → TBL_CENTERMEMBER.CENTER_MEMBER_NO — NOT NULL
  • FILE_NAME — VARCHAR2(1000) — NOT NULL
  • STORED_FILE_NAME — VARCHAR2(1000) — NOT NULL
  • FILE_UUID — VARCHAR2(1000) — NOT NULL
  • FILE_PATH — NUMBER — NOT NULL
  • UPLOAD_TIME — DATE — NOT NULL

TBL_COMMENT_REPORT

  • COMMENT_REPORT_NO — NUMBER — Primary key — NOT NULL
  • COMMENT_REPORT_CATE — VARCHAR2(100) — NOT NULL
  • COMMENT_REPORT — VARCHAR2(100) — NOT NULL
  • COMMENT_REPORT_WRITER — NUMBER — NOT NULL
  • COMMENT_REPORT_REGIDATE — DATE — NOT NULL
  • COMMENT_NO — NUMBER — NOT NULL
  • CONTENT_NO — NUMBER — NOT NULL

TBL_COMMU

  • COMMU_NUMBER — NUMBER — Primary key — NOT NULL
  • COMMU_CATE — VARCHAR2(1000 ) — NOT NULL
  • COMMU_CONTENT — VARCHAR2(1000) — NOT NULL
  • COMMU_REGIDATE — DATE — NOT NULL
  • COMMU_UPDATEDATE — DATE — NOT NULL
  • COMMU_GOOD — NUMBER — NOT NULL
  • COMMU_WRITER — NUMBER — NOT NULL

TBL_COMMU_COMMENT

  • COMMU_COMMENT_NO — NUMBER — Primary key — NOT NULL
  • COMMU_NUMBER — NUMBER — Foreign key → TBL_COMMU.COMMU_NUMBER — NOT NULL
  • COMMU_COMMENT — VARCHAR2(1000) — NOT NULL
  • COMMU_COMMET_REGIDATE — DATE — NOT NULL
  • COMMU_UPDATEDATE — DATE — NOT NULL
  • COMMU_COMMENT_WRITER — NUMBER — NOT NULL

TBL_COMMU_FILE

  • FILE_NO — NUMBER — Primary key — NOT NULL
  • COMMU_NUMBER — NUMBER — Foreign key → TBL_COMMU.COMMU_NUMBER — NOT NULL
  • FILE_NAME — VARCHAR2(1000) — NOT NULL
  • STORED_FILE_NAME — VARCHAR2(1000) — NOT NULL
  • FILE_UUID — VARCHAR2(1000) — NOT NULL
  • FILE_PATH — NUMBER — NOT NULL
  • UPLOAD_TIME — DATE — NOT NULL

TBL_DONA

  • DONA_NO — NUMBER — Primary key — NOT NULL
  • CENTER_MEMBER_NO — NUMBER — Foreign key → TBL_CENTERMEMBER.CENTER_MEMBER_NO — NOT NULL
  • DONA_TITLE — VARCHAR2(1000) — NOT NULL
  • DONA_CONTENT — VARCHAR2(1000) — NOT NULL
  • DONA_REGIDATE — DATE
  • DONA_UPDATEDATE — DATE

TBL_DONACOMMENT (TBL_DONA_COMMENT)

  • DONA_COMMENT_NO — NUMBER — Primary key — NOT NULL
  • DONA_NO — NUMBER — Foreign key → TBL_DONA.DONA_NO — NOT NULL
  • DONA_COMMENT_CONTENT — VARCHAR2(1000) — NOT NULL
  • DONA_COMMENT_REGIDATE — DATE — NOT NULL
  • DONA_COMMENT_UPDATEDATE — DATE — NOT NULL
  • DONA_COMMENT_WRITER — NUMBER — NOT NULL

TBL_DONA_FILE

  • FILE_NO — NUMBER — Primary key — NOT NULL
  • DONA_NO — NUMBER — Foreign key → TBL_DONA.DONA_NO — NOT NULL
  • FILE_NAME — VARCHAR2(1000) — NOT NULL
  • STORED_FILE_NAME — VARCHAR2(1000) — NOT NULL
  • FILE_UUID — VARCHAR2(1000) — NOT NULL
  • FILE_PATH — NUMBER — NOT NULL
  • UPLOAD_TIME — DATE — NOT NULL

TBL_MEMBER

  • MEMBER_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — VARCHAR2(1000) — NOT NULL
  • MEMBER_PASSWORD — VARCHAR2(1000) — NOT NULL
  • MEMBER_EMAIL — VARCHAR2(1000) — NOT NULL
  • MEMBER_NICKNAME — VARCHAR2(1000) — NOT NULL
  • MEMBER_PHONE_NUMBER — VARCHAR2(1000) — NOT NULL
  • MEMBER_GENDER — CHAR(1) — NOT NULL
  • MEMBER_ZIPCODE — VARCHAR2(1000) — NOT NULL
  • MEMBER_ADDRESS — VARCHAR2(1000) — NOT NULL
  • MEMBER_DETAIL_ADDRESS — VARCHAR2(1000) — NOT NULL
  • MEMBER_STATUS — CHAR(1) — NOT NULL
  • MEMBER_LOGIN_STATUS — VARCHAR2(1000) — NOT NULL
  • MEMBER_TWO_FACTOR_ENABLED — CHAR(1) — NOT NULL

TBL_NOTEBOX_RECEIVE

  • NOTEBOX_RECEIVE_NO — NUMBER — Primary key — NOT NULL
  • NOTEBOX_RECEIVE_TITLE — VARCHAR2(1000) — NOT NULL
  • NOTEBOX_RECEIVE_CONTENT — VARCHAR2(1000) — NOT NULL
  • NOTEBOX_RECEIVE_REGIDATE — VARCHAR2(1000) — NOT NULL
  • NOTEBOX_RECEIVE_READ — CHAR(1) — NOT NULL
  • NOTEBOX_RECEIVE_S — NUMBER — NOT NULL
  • NOTEBOX_RECEIVE_R — NUMBER — NOT NULL

TBL_NOTEBOX_SEND

  • NOTEBOX_SEND_NO — NUMBER — Primary key — NOT NULL
  • NOTEBOX_SEND_TITLE — VARCHAR2(1000) — NOT NULL
  • NOTEBOX_SEND_CONTENT — VARCHAR2(1000) — NOT NULL
  • NOTEBOX_SEND_REGIDATE — DATE — NOT NULL
  • NOTEBOX_SEND_S — NUMBER — NOT NULL
  • NOTEBOX_SEND_R — NUMBER — NOT NULL

TBL_NOTICE

  • NOTICE_NO — NUMBER — Primary key — NOT NULL
  • ADMIN_NO — NUMBER — Foreign key → TBL_ADMIN.ADMIN_NO — NOT NULL
  • NOTICE_CATE — VARCHAR2(1000) — NOT NULL
  • NOTICE_TITLE — VARCHAR2(1000) — NOT NULL
  • NOTICE_CONTENT — VARCHAR2(1000) — NOT NULL
  • NOTICE_REGIDATE — DATE — NOT NULL
  • NOTICE_UPDATEDATE — DATE — NOT NULL

TBL_NOTICE_FILE

  • FILE_NO — NUMBER — Primary key — NOT NULL
  • NOTICE_NO — NUMBER — Foreign key → TBL_NOTICE.NOTICE_NO — NOT NULL
  • FILE_NAME — VARCHAR2(1000) — NOT NULL
  • STORED_FILE_NAME — VARCHAR2(1000) — NOT NULL
  • FILE_UUID — VARCHAR2(1000) — NOT NULL
  • FILE_PATH — NUMBER — NOT NULL
  • UPLOAD_TIME — DATE — NOT NULL

TBL_PROTECT

  • PROTECT_NO — NUMBER — Primary key — NOT NULL
  • CENTER_MEMBER_NO — NUMBER — Foreign key → TBL_CENTERMEMBER.CENTER_MEMBER_NO — NOT NULL
  • PROTECT_PERIODSTART — DATE — NOT NULL
  • PROTECT_PERIODEND — DATE — NOT NULL
  • PROTECT_BREAD — VARCHAR2(1000) — NOT NULL
  • PROTECT_NEUTERING — CHAR(1) — NOT NULL
  • PROTECT_GENDER — CHAR(1) — NOT NULL
  • PROTECT_WEIGHT — VARCHAR2(1000) — NOT NULL
  • PROTECT_BIRTH — DATE — NOT NULL
  • PROTECT_INTRODUCE — VARCHAR2(1000) — NOT NULL
  • PROTECT_TITLE — VARCHAR2(1000) — NOT NULL
  • PROTECT_CONTENT — VARCHAR2(1000) — NOT NULL
  • PROTECT_REGIDATE — DATE — NOT NULL
  • PROTECT_UPDATEDATE — DATE

TBL_PROTECT_COMMENT

  • PROTECT_COMMENT_NO — NUMBER — Primary key — NOT NULL
  • PROTECT_NO — NUMBER — Foreign key → TBL_PROTECT.PROTECT_NO — NOT NULL
  • PROTECT_COMMENT — VARCHAR2(1000) — NOT NULL
  • PROTECT_COMMENT_REGIDATE — DATE — NOT NULL
  • PROTECT_COMMENT_REPORT_WRITER — DATE — NOT NULL

TBL_PROTECT_FILE

  • FILE_NO — NUMBER — Primary key — NOT NULL
  • PROTECT_NO — NUMBER — Foreign key → TBL_PROTECT.PROTECT_NO — NOT NULL
  • FILE_NAME — VARCHAR2(1000) — NOT NULL
  • STORED_FILE_NAME — VARCHAR2(1000) — NOT NULL
  • FILE_UUID — VARCHAR2(1000) — NOT NULL
  • FILE_PATH — NUMBER — NOT NULL
  • UPLOAD_TIME — DATE — NOT NULL

TBL_PROTECT_REQUEST

  • PROTECT_REQUEST_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → TBL_MEMBER.MEMBER_NO — NOT NULL
  • PROTECT_NO — NUMBER — Foreign key → TBL_PROTECT.PROTECT_NO — NOT NULL
  • CENTER_MEMBER_NO — NUMBER — Foreign key → TBL_PROTECT.CENTER_MEMBER_NO — NOT NULL
  • PROTECT_REQUEST_NAME — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_PHONE — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_PHONE_SUB — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_EMAIL — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_GENDER — CHAR(1) — NOT NULL
  • PROTECT_REQUEST_AGE — DATE — NOT NULL
  • PROTECT_REQUEST_ZIPCODE — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_ADDRESS — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_ADDR_DETAIL — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_JOB — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_MARRY — CHAR(1) — NOT NULL
  • PROTECT_REQUEST_INFO_AGREE — CHAR(1) — NOT NULL
  • PROTECT_REQUEST_Q1 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q2 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q3 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q4 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q5 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q6 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q7 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q8 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q9 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q10 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q11 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q12 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q13 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q14 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_Q15 — VARCHAR2(1000) — NOT NULL
  • PROTECT_REQUEST_PROTECT_AGREE — CHAR(1) — NOT NULL

TBL_REPORT

  • REPORT_NO — NUMBER — Primary key — NOT NULL
  • REPORT_CATE — VARCHAR2(100) — NOT NULL
  • REPORT_CONTENT — VARCHAR2(200)
  • REPORT_REGIDATE — DATE — NOT NULL
  • REPORT_WRITER — NUMBER — NOT NULL
  • REPORT_CONTENT_NO — NUMBER — NOT NULL

TBL_REVIEW

  • REVIEW_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → TBL_MEMBER.MEMBER_NO — NOT NULL
  • REVIEW_TITLE — VARCHAR2(1000) — NOT NULL
  • REVIEW_CONTENT — VARCHAR2(1000) — NOT NULL
  • REVIEW_REGIDATE — DATE
  • REVIEW_UPDATEDATE — DATE
  • REVIEW_PRICTURE — VARCHAR2(1000)

TBL_REVIEW_COMMENT

  • REVIEW_COMMENT_NO — NUMBER — Primary key — NOT NULL
  • REVIEW_NO — NUMBER — Foreign key → TBL_REVIEW.REVIEW_NO — NOT NULL
  • VARCHAR2(1000) — VARCHAR2(1000) — NOT NULL
  • REVIEW_COMMENT_REGIDATE — DATE
  • REVIEW_COMMENT_UPDATEDATE — DATE
  • REVIEW_COMMENT_WRITER — NUMBER — NOT NULL

TBL_REVIEW_FILE

  • FILE_NO — NUMBER — Primary key — NOT NULL
  • REVIEW_NO — NUMBER — Foreign key → TBL_REVIEW.REVIEW_NO — NOT NULL
  • FILE_NAME — VARCHAR2(1000) — NOT NULL
  • STORED_FILE_NAME — VARCHAR2(1000) — NOT NULL
  • FILE_UUID — VARCHAR2(1000) — NOT NULL
  • FILE_PATH — NUMBER — NOT NULL
  • UPLOAD_TIME — DATE — NOT NULL

TBL_VOLUN

  • VOLUN_NO — NUMBER — Primary key — NOT NULL
  • CENTER_MEMBER_NO — NUMBER — Foreign key → TBL_CENTERMEMBER.CENTER_MEMBER_NO — NOT NULL
  • VOLUN_PERIODSTART — DATE — NOT NULL
  • VOLUN_PERIODEND — DATE — NOT NULL
  • VOLUN_START — DATE — NOT NULL
  • VOLUN_END — DATE — NOT NULL
  • VOLUN_LOCAL — VARCHAR2(1000) — NOT NULL
  • VOLUN_TIME — VARCHAR2(1000) — NOT NULL
  • VOLUN_PEOPLE — VARCHAR2(1000) — NOT NULL
  • VOLUN_TITLE — VARCHAR2(1000) — NOT NULL
  • VOLUN_CONTENT — VARCHAR2(1000) — NOT NULL
  • VOLUN_REGIDATE — DATE
  • VOLUN_UPDATEDATE — DATE
  • VOLUN_PRICTURE — VARCHAR2(1000)

TBL_VOLUN_COMMNET

  • VOLUN_COMMENT_NO — NUMBER — Primary key — NOT NULL
  • VOLUN_NO — NUMBER — Foreign key → TBL_VOLUN.VOLUN_NO — NOT NULL
  • VOLUN_COMMENT — VARCHAR2(1000) — NOT NULL
  • VOLUN_REGIDATE_DATE — DATE — NOT NULL
  • VOLUN_UPDATE_DATE — DATE — NOT NULL
  • VOLUN_COMMENT_WRITER — NUMBER — NOT NULL

TBL_VOLUN_FILE

  • FILE_NO — NUMBER — Primary key — NOT NULL
  • VOLUN_NO — NUMBER — Foreign key → TBL_VOLUN.VOLUN_NO — NOT NULL
  • FILE_NAME — VARCHAR2(1000) — NOT NULL
  • STORED_FILE_NAME — VARCHAR2(1000) — NOT NULL
  • FILE_UUID — VARCHAR2(1000) — NOT NULL
  • FILE_PATH — NUMBER — NOT NULL
  • UPLOAD_TIME — DATE — NOT NULL

TBL_VOLUN_REQUEST

  • VOLUN_REQUEST_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → TBL_MEMBER.MEMBER_NO — NOT NULL
  • VOLUN_NO — NUMBER — Foreign key → TBL_VOLUN.VOLUN_NO — NOT NULL
  • CENTER_MEMBER_NO — NUMBER — Foreign key → TBL_VOLUN.CENTER_MEMBER_NO — NOT NULL
  • VOLUN_REQUEST_NAME — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_PHONE — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_PHONE_SUB — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_EMAIL — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_GENDER — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_AGE — DATE — NOT NULL
  • VOLUN_REQUEST_ZIPCODE — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_ADDRESS — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_ADDRESS_DETAIL — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_JOB — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_MARRY — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_AGREEMENT — CHAR(1) — NOT NULL
  • VOLUN_REQUEST_Q1 — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_Q2 — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_Q3 — VARCHAR2(1000) — NOT NULL
  • VOLUN_REQUEST_Q4 — VARCHAR2(1000) — NOT NULL