NaverExternship

Tables (6)

ClickPerUrl (url별 클릭 횟수)

  • id (아이디) — Long — Primary key — NOT NULL
  • click (클릭수) — Long
  • date (날짜) — LocalDate
  • shortKey (키) — varchar — Foreign key → Url.shortKey — NOT NULL

Device (디바이스명)

  • deviceType (디바이스명) — varchar — Primary key — NOT NULL

DevicePerUrl (url별 디바이스)

  • id (아이디) — Long — Primary key — NOT NULL
  • click (클릭수) — Long
  • date (날짜) — LocalDate
  • shortKey (키) — varchar — Foreign key → Url.shortKey — NOT NULL
  • deviceType (디바이스명) — varchar — Foreign key → Device.deviceType — NOT NULL

Referrer (참조 url)

  • referrer (참조 url) — varchar — Primary key — NOT NULL

ReferrerPerUrl (url별 참조 url)

  • id (아이디) — Long — Primary key — NOT NULL
  • click (클릭수) — Long
  • date (날짜) — LocalDate
  • shortKey (키) — varchar — Foreign key → Url.shortKey — NOT NULL
  • referrer (참조 url) — varchar — Foreign key → Referrer.referrer — NOT NULL

Url (url)

  • shortKey (키) — varchar — Primary key — NOT NULL
  • shortUrl (줄인 url) — varchar
  • originalUrl (원리 url) — varchar
  • createdAt (생성일) — LocalDateTime
  • expiredAt (만료일) — LocalDateTime
  • totalClicks (전체클릭수) — Long
  • lastClickedAt (마지막 클릭 시간) — LocalDateTime