대피소 프로젝트

테이블 (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