BOARD

테이블 (11)

AGREEMENT

  • ID — VARCHAR2(38)
  • AGREE_CODE_01 — VARCHAR2(10)
  • AGREE_CODE_02 — VARCHAR2(10)
  • AGREE_CODE_03 — VARCHAR2(10)

PAR

  • ID — VARCHAR2(38)
  • C_NAME — VARCHAR2(38) — NOT NULL
  • BIRTHYEAR — DATE — NOT NULL
  • C_GENDER — VARCHAR(10) — NOT NULL
  • PERSONALITY — VARCHAR(2000) — NOT NULL
  • ETC — VARCHAR(2000)

REPORT_USERS

  • REPORT_NUM — NUMBER(10)
  • PARENT_ID — VARCHAR2(38)
  • SENIOR_ID — VARCHAR2(38)
  • NAME — VARCHAR2(38)
  • REPORTED_REASON — VARCHAR2(1000)
  • REPORT_DATE — DATE
  • REPORT_CONFIRM_STATUS — VARCHAR2(8)
  • REPORT_COUNT — NUMBER(1)

SNR

  • ID — VARCHAR2(38)
  • INFO — VARCHAR2(2000)
  • AREA — VARCHAR2(300)

USER_INFO

  • ID — VARCHAR2(38)
  • PASSWORD — VARCHAR2(38) — NOT NULL
  • NAME — VARCHAR2(38) — NOT NULL
  • BIRTHDAY — DATE — NOT NULL
  • PHONE_NUMBER — VARCHAR2(50) — NOT NULL
  • POST_CODE — VARCHAR2(20) — NOT NULL
  • ADDRESS — VARCHAR2(300) — NOT NULL
  • DETAIL_ADDRESS — VARCHAR2(300)
  • EXTRA_ADDRESS — VARCHAR2(30)
  • GENDER — VARCHAR2(1) — NOT NULL
  • EMAIL — VARCHAR2(100)
  • USER_CODE — VARCHAR2(10) — NOT NULL
  • REG_DATE — DATE

VERIFICATION

  • verification_num — number(10)
  • idcpicture — varchar2(40)
  • cmnpicture — varchar2(40)
  • id — varchar2(50)
  • verification_status — VARCHAR2(8)

mailbox

  • no — number — 기본 키
  • rev_id — varchar2(38)
  • send_id — varchar2(38)
  • content — varchar2(1000)
  • matching_number — number
  • status — varchar2(10)
  • send_time — date

matching_d

  • matching_number — number
  • schedule_code — varchar2(8)
  • day — date
  • status — varchar2(24)

matching_m

  • matching_number — number
  • snr_id — varchar2(38)
  • par_id — varchar2(38)
  • start_date — date
  • end_date — date
  • schedule_code — varchar2(300)
  • pick_up_place — varchar2(300)
  • arrive_place — varchar2(300)
  • status — varchar2(24)

senior_enable_schedule

  • id — varchar2(38) — 기본 키
  • schedule_code — varchar2(8)
  • status — varchar2(2)
  • work_status — varchar2(2)

게시판 (BOARD)

  • 글번호 (article_no) — NUMBER — 기본 키 — NOT NULL
  • 부모글 (parent_no) — NUMBER — NOT NULL
  • 제목 (title) — VARCHAR2 — NOT NULL
  • 내용 (content) — VARCHAR2 — NOT NULL
  • 작성자 (id) — VARCHAR2 — NOT NULL
  • 작성일 (created_at) — DATE — NOT NULL
  • 조회수 (views) — NUMBER — NOT NULL