맛집노트

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