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