맛집노트
테이블 (8)
INFLUENCER_INFO (인플루언서)
- INFLUENCER_ID (Key1) — VARCHAR(50) — 기본 키 — NOT NULL
- INFLUENCER_IN TRODUCE (Field2) — VARCHAR(1000) — NOT NULL
- CREATE_DT (Field3) — DATETIME — NOT NULL
- RENEW_DT (Field4) — DATETTIME — NOT NULL
- INSERTED_USER_ID (FKey1) — 외래 키 → USER_INFO.USER_ID — NOT NULL
INFLUENCER_MUST_GO (인플루언서 맛집)
- POST_IDX (Key1) — INT — 기본 키 — NOT NULL — Auto Increment
- INFLUENCER_ID (Key12) — VARCHAR(50) — 외래 키 → INFLUENCER_INFO.INFLUENCER_ID — NOT NULL
- ADDRESS (Field1) — VARCHAR(1000) — NOT NULL
- PERMA_LINK (Field2) — VARCHAR(1000) — NOT NULL
- RESTAURANT_INFO (Field3) — VARCHAR(1000)
- SNS_UPLOAD_DT (Field4) — DATETIME — NOT NULL
- CREATE_DT (Field5) — DATETIME — NOT NULL
INFLUENCER_MUST_GO_DETAIL (인플루언서 맛집 상세정보)
- POST_IDX (FKey1) — INT — 외래 키 → INFLUENCER_MUST_GO.POST_IDX — NOT NULL
- INFLUENCER_ID (Key12) — VARCHAR(50) — 외래 키 → INFLUENCER_MUST_GO.INFLUENCER_ID — NOT NULL
- RESTAURANT_NAME (Field1) — VARCHAR(1000) — NOT NULL
- RESTAURANT_TYPE (Field2) — VARCHAR(1000) — NOT NULL
SERVER_LOG (서버 로그)
- LOG_IDX (Key1) — INT — 기본 키 — NOT NULL — AUTO INCREMENT
- USER_IP (Field1) — VARCHAR(100)
- REQEUST_)METHOD (Field7) — VARCHAR(1000)
- REQUEST_URL (Field2) — VARCHAR(1000)
- REQUEST_PARAMS (Field3) — VARCHAR(1000)
- REQUEST_TIME (Field6) — DATETIME
- RESPONSE_STATUS (Field4) — VARCHAR(100)
- RESPONSE_COMMENT (Field5) — VARCHAR(1000)
- RESPONSE_TIME (Field8) — DATETIME
- EXECUTION_TIME (Field9) — VARCHAR(100)
USER_INFO (사용자)
- USER_ID (Key1) — VARCHAR(50) — 기본 키 — NOT NULL
- USER_PW (Field1) — VARCHAR(100) — NOT NULL
- EMAIL (Field2) — VARCHAR(100) — NOT NULL — UNIQUE
- CREATEDT (Field3) — DATETIME — NOT NULL
- IS_DELETED (Field4) — BOOLEAN
- DELETEDT (Field5) — DATETIME
- IS_ADMIN (Field6) — BOOLEAN
USER_MUST_GO (사용자 맛집)
- POST_IDX (Key) — INT — 기본 키 — NOT NULL — Auto Increment
- ADDRESS (Field1) — VARCHAR(1000) — NOT NULL
- RESTAURANT_NAME (Field2) — VARCHAR(1000) — NOT NULL
- RESTAURANT_INFO (Field3) — VARCHAR(1000)
- CREATEDT (Field4) — DATETIME — NOT NULL
- USER_ID (FKey1) — VARCHAR(50) — 외래 키 → USER_INFO.USER_ID — NOT NULL — USER_ID + ADDRESS + RESTAURANT_NAME 세개 속성에 대해 UNIQUE
USER_RELATION (사용자간 관계)
- IDX (Key1) — INT — 기본 키 — NOT NULL — Auto Increment
- FRIEND_ID (FKey2) — VARCHAR(50) — 기본 키 — NOT NULL
- USER_ID (FKey1) — VARCHAR(50) — 외래 키 → USER_INFO.USER_ID — NOT NULL — USER_ID + FRIEND_ID 두개 속성에 대해 UNIQUE
- CREATEDT (Field1) — DATETIME — NOT NULL
USER_WISH_BY_FRIEND (사용자가 가고 싶은 맛집)
- IDX (Key1) — INT — 기본 키 — NOT NULL — Auto Increment
- USER_ID (FKey1) — VARCHAR(50) — 외래 키 → USER_INFO.USER_ID — NOT NULL
- POST_IDX (FKey2) — INT — 외래 키 → USER_MUST_GO.POST_IDX — NOT NULL — USER_ID + FRIEND_POST_IDX 두개 속성에 대해 UNIQUE
- CREATE_DT (Field1) — DATETIME — NOT NULL
- IS_VISIT (Field2) — BOOLEAN — NOT NULL
- POST_TYPE (Field3) — ENUM — NOT NULL