윌리윌리

테이블 (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_IDX2 — NUMBER(18, 0) — NOT NULL
  • CCTV_IDX — NUMBER(18, 0) — 외래 키 → CCTV.CCTV_IDX
  • CAPTURE_FIRST_TIME — DATE
  • CAPTURE_PATH — VARCHAR2(200)
  • CAPTURE_ALARM_CK — TINYINT(1)
  • CAPTURE_ALARM_CK_TIME — DATETIME

CCTV

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

MISSING

  • MISSING_IDX — NUMBER(18, 0) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(30) — 외래 키 → USER.USER_ID — NOT NULL
  • MISSING_NAME — VARCHAR2(30)
  • MISSING_GENDER — VARCHAR2(10)
  • MISSING_AGE — VARCHAR2(20)
  • 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)
  • MISSING_TOP_COLOR — VARCHAR2(20)
  • MISSING_BOTTOMS — VARCHAR2(50)
  • MISSING_BOTTOMS_COLOR — VARCHAR2(20)
  • 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
  • POSTER_VIEW — INT
  • POSTER_IMG_PATH — VARCHAR2(500)
  • POSTER_SHOW — TINYINT(1)

REPORT

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

USER

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