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