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