대피소 프로젝트
테이블 (18)
DISASTER_ZONE
- ID — NUMBER
- DISASTER_TYPE — VARCHAR2(100) — NOT NULL
- LATITUDE — NUMBER(10, 7)
- LONGITUDE — NUMBER(10, 7)
- RADIUS — NUMBER
- AREA_NAME — VARCHAR2(100)
- START_TIME — TIMESTAMP
- EXPIRY_TIME — TIMESTAMP — NOT NULL
DM
- DMID — NUMBER
- DISASTER_TYPE — VARCHAR2(100)
- AREA — VARCHAR2(200)
- SENT_DATE — VARCHAR2(100)
- CONTENT — CLOB
FIRE_STATION_DETAIL
- FACILITY_ID — NUMBER
- PHONE_NUMBER_HQ — VARCHAR2(100)
- SUB_TYPE — VARCHAR2(100)
HOSPITAL_DETAIL
- FACILITY_ID — NUMBER
- PHONE_NUMBER — VARCHAR2(100)
- ROAD_ADDRESS — VARCHAR2(1000)
- SUB_TYPE — VARCHAR2(100)
- HAS_EMERGENCY_ROOM — CHAR(1)
- BED_COUNT — NUMBER
- STAFF_COUNT — NUMBER
- OPERATING_STATUS — VARCHAR2(100)
POLICE_DETAIL
- FACILITY_ID — NUMBER
- PHONE_NUMBER — VARCHAR2(100)
- GUBUN — VARCHAR2(100)
- SIDO_CHEONG — VARCHAR2(100)
SAFETY_ACCESS_LOG
- LOG_ID — NUMBER
- USER_ID — VARCHAR2(50) — NOT NULL
- ACCESS_TYPE — VARCHAR2(20) — NOT NULL
- IP_ADDRESS — VARCHAR2(50)
- USER_AGENT — VARCHAR2(1000)
- LOG_DATE — DATE
SAFETY_BOARD
- BOARD_ID — NUMBER
- USER_ID — VARCHAR2(50) — NOT NULL
- TITLE — VARCHAR2(100) — NOT NULL
- CONTENT — VARCHAR2(2000) — NOT NULL
- CATEGORY — VARCHAR2(50)
- LATITUDE — NUMBER(10, 7) — NOT NULL
- LONGITUDE — NUMBER(10, 7) — NOT NULL
- IMAGE_URL — VARCHAR2(300)
- LOCATION_TYPE — VARCHAR2(20)
- VIEW_COUNT — NUMBER
- CREATED_AT — DATE
SAFETY_BOARD_LIKE
- LIKE_ID — NUMBER
- BOARD_ID — NUMBER — NOT NULL
- USER_ID — VARCHAR2(50) — NOT NULL
SAFETY_COMMENT
- COMMENT — ON) — NOT NULL — N) */_ID NUMBER PRIMARY KEY BOARD_ID NUMBER NOT NUL
- USER_ID — VARCHAR2(50) — NOT NULL
- CONTENT — VARCHAR2(500) — NOT NULL
- PARENT_ID — NUMBER
- CREATED_AT — DATE
SAFETY_FAMILY
- FAMILY_ID — NUMBER
- USER_ID — VARCHAR2(50) — NOT NULL
- NAME — VARCHAR2(50) — NOT NULL
- PHONE — VARCHAR2(20) — NOT NULL
- CREATED_AT — DATE
SAFETY_INQUIRY
- INQUIRY_ID — NUMBER
- TITLE — VARCHAR2(100) — NOT NULL
- CONTENT — VARCHAR2(2000) — NOT NULL
- CATEGORY — VARCHAR2(50) — NOT NULL
- IMAGE_URL — VARCHAR2(255)
- WRITER_ID — VARCHAR2(50) — NOT NULL
- WRITER_NAME — VARCHAR2(50) — NOT NULL
- STATUS — VARCHAR2(20)
- IS_SECRET — NUMBER(1, 0)
- ANSWER_CONTENT — VARCHAR2(2000)
- ANSWER_DATE — TIMESTAMP
- CREATED_DATE — TIMESTAMP
SAFETY_MEMBER
- USER_ID — VARCHAR2(50)
- EMAIL — VARCHAR2(100) — NOT NULL — 이메일
- PASSWORD — VARCHAR2(255) — NOT NULL
- NAME — VARCHAR2(50) — NOT NULL — 이름
- NICKNAME — VARCHAR2(50) — NOT NULL — 닉네임
- ADDRESS — VARCHAR2(300) — NOT NULL — 주소
- DETAIL_ADDRESS — VARCHAR2(300)
- AREA_NAME — VARCHAR2(100)
- LATITUDE — NUMBER(10, 7) — 위도
- LONGITUDE — NUMBER(10, 7) — 경도
- EMERGENCY_PHONE — VARCHAR2(20)
- PW_QUESTION — NUMBER(2) — NOT NULL
- PW_ANSWER — VARCHAR2(200) — NOT NULL
- JOIN_DATE — DATE — 가입일
SAFETY_MY_PLACE
- PLACE_ID — NUMBER
- USER_ID — VARCHAR2(50) — NOT NULL
- PLACE_TYPE — VARCHAR2(20) — NOT NULL
- PLACE_NAME — VARCHAR2(100)
- ADDRESS — VARCHAR2(300) — NOT NULL
- LATITUDE — NUMBER(10, 7) — NOT NULL
- LONGITUDE — NUMBER(10, 7) — NOT NULL
- CREATED_AT — DATE
SAFETY_NOTICE
- NOTICE_ID — NUMBER
- TITLE — VARCHAR2(200) — NOT NULL
- CONTENT — VARCHAR2(4000) — NOT NULL
- TYPE — VARCHAR2(20) — NOT NULL
- VIEW_COUNT — NUMBER
- CREATED_DATE — TIMESTAMP
- ATTACHMENT_URL — VARCHAR2(255)
- WRITER_ID — VARCHAR2(50) — NOT NULL
- WRITER_NAME — VARCHAR2(50) — NOT NULL
SAFETY_REPORT
- REPORT_ID — NUMBER
- REPORTER_ID — VARCHAR2(50) — NOT NULL
- TARGET_TYPE — VARCHAR2(50) — NOT NULL
- TARGET_ID — NUMBER
- TARGET_USER_ID — VARCHAR2(50)
- REASON — VARCHAR2(100) — NOT NULL
- DESCRIPTION — CLOB
- STATUS — VARCHAR2(20)
- CREATED_AT — TIMESTAMP
SHELTER_DETAIL
- FACILITY_ID — NUMBER
- OPERATING_STATUS — VARCHAR2(100)
- AREA_M2 — NUMBER(10, 2)
- MAX_CAPACITY — NUMBER
- LOCATION_TYPE — VARCHAR2(100)
USER_BLOCK
- ID — NUMBER
- USER_ID — VARCHAR2(50) — NOT NULL
- BLOCKED_USER_ID — VARCHAR2(50) — NOT NULL
- CREATED_AT — TIMESTAMP
USER_SUSPENSION
- ID — NUMBER
- TARGET_USER_ID — VARCHAR2(50) — NOT NULL
- REASON — VARCHAR2(255)
- START_AT — TIMESTAMP
- END_AT — TIMESTAMP
- CREATED_BY — VARCHAR2(50)
- CREATED_AT — TIMESTAMP