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