linkTree

Tables (4)

Link

  • id — BIGINT (PK) — Primary key — NOT NULL
  • user_id — BIGINT (FK, User.id 참조)
  • title — VARCHAR(255)
  • url — VARCHAR(255)
  • order_index — INT
  • click_count — INT (DEFAULT 0)
  • created_at — TIMESTAMP

Profile

  • id — BIGINT(PK) — Primary key — NOT NULL
  • user_id — BIGINT(FK, User.id 참조)
  • bio — VARCHAR(255)
  • profile_img — VARCHAR(255)
  • theme — VARCHAR(50)
  • created_at — TIMESTAMP

User

  • id — BIGINT (PK) — Primary key — NOT NULL
  • email — VARCHAR(255) (UNIQUE)
  • password — VARCHAR(255)
  • nickname — VARCHAR(255)
  • created_at — TIMESTAMP

VisitLog

  • id — BIGINT (PK) — Primary key — NOT NULL
  • user_id — BIGINT (FK, User.id 참조)
  • ip_address — VARCHAR(50)
  • device — VARCHAR(100)
  • created_at — TIMESTAMP