윌리윌리

테이블 (9)

AUTH

  • AUTH_ID — VARCHAR2(30) — 기본 키 — NOT NULL
  • SNS_PROVIDER — VARCHAR2(30) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(30) — 외래 키 → USER.USER_ID — NOT NULL

BELONGINGS

  • BELONGINGS_IDX — INT — 기본 키 — NOT NULL
  • MISSING_IDX — NUMBER(18, 0) — 외래 키 → MISSING.MISSING_IDX — NOT NULL
  • BELONGINGS_CATE — VARCHAR2(30)
  • BELONGINGS_ETC — VARCHAR2(50)

CAPTURE

  • CAPTURE_IDX — INT — 기본 키 — NOT NULL
  • MISSING_IDX — NUMBER(18, 0) — 외래 키 → MISSING.MISSING_IDX — NOT NULL
  • CCTV_IDX — NUMBER(18, 0) — 외래 키 → CCTV.CCTV_IDX — NOT NULL
  • CAPTURE_FIRST_TIME — DATE — NOT NULL
  • CAPTURE_PATH — VARCHAR2(200) — NOT NULL
  • CAPTURE_ALARM_CK — TINYINT(1) — NOT NULL
  • CAPTURE_ALARM_CK_TIME — DATETIME

CCTV

  • CCTV_IDX — NUMBER(18, 0) — 기본 키 — NOT NULL
  • CCTV_LAT — DOUBLE — NOT NULL
  • CCTV_LNG — DOUBLE — NOT NULL
  • CCTV_LOAD_ADDRESS — VARCHAR2(200) — NOT NULL
  • CCTV_PATH — VARCHAR2(100) — NOT NULL

MISSING

  • MISSING_IDX — NUMBER(18, 0) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(30) — 외래 키 → USER.USER_ID — NOT NULL
  • MISSING_NAME — VARCHAR2(30) — NOT NULL
  • MISSING_GENDER — VARCHAR2(10) — NOT NULL
  • MISSING_AGE — VARCHAR2(20) — NOT NULL
  • MISSING_IMG — VARCHAR2(500)
  • MISSING_SIGHTING_LOCATION — VARCHAR2(200)

MISSING_CLOTHES

  • MISSING_CLOTHES_IDX — INT — 기본 키 — NOT NULL
  • MISSING_IDX — NUMBER(18, 0) — 외래 키 → MISSING.MISSING_IDX — NOT NULL
  • MISSING_TOP — VARCHAR2(50) — NOT NULL
  • MISSING_TOP_COLOR — VARCHAR2(20) — NOT NULL
  • MISSING_BOTTOMS — VARCHAR2(50) — NOT NULL
  • MISSING_BOTTOMS_COLOR — VARCHAR2(20) — NOT NULL
  • MISSING_CLOTHES_ETC — VARCHAR2(30)

POSTER

  • POSTER_IDX — INT — 기본 키 — NOT NULL
  • MISSING_IDX — NUMBER(18, 0) — 외래 키 → MISSING.MISSING_IDX — NOT NULL
  • POSTER_CREATED_AT — DATE — NOT NULL
  • POSTER_VIEW — INT
  • POSTER_IMG_PATH — VARCHAR2(500)
  • POSTER_SHOW — TINYINT(1) — NOT NULL

REPORT

  • REPORT_ID — INT — 기본 키 — NOT NULL
  • POSTER_IDX — INT — NOT NULL
  • REPORT_TIME — DATETIME — NOT NULL
  • REPORT_SIGHTING_TIME — DATETIME — NOT NULL
  • REPORT_SIGHTING_PLACE — VARCHAR2(100) — NOT NULL
  • REPORT_ETC — VARCHAR2(200)
  • REPORT_NOTIFICATION — VARCHAR2(200) — NOT NULL
  • REPORT_CK_TIME — DATETIME

USER

  • USER_ID — VARCHAR2(30) — 기본 키 — NOT NULL
  • USER_PW — VARCHAR2(100)
  • USER_NAME — VARCHAR2(30) — NOT NULL
  • USER_BRT_DT — DATE
  • USER_GENDER — CHAR(1)
  • USER_PHONE — VARCHAR2(20)