memory
Tables (5)
friend_requests
- id — BIGINT
- from_user_id — BIGINT — Foreign key → users.id — NOT NULL
- to_user_id — BIGINT — Foreign key → users.id — NOT NULL
- status — ENUM('pending', 'accepted', 'rejected')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
friends
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- friend_user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
memories
- id — BIGINT
- uploader_id — BIGINT — Foreign key → users.id — NOT NULL
- image_url — TEXT — NOT NULL
- title — VARCHAR(255)
- description — TEXT
- uploaded_at — TIMESTAMP
- visibility — ENUM('private', 'friends', 'people_included', 'public')
- is_deleted — TINYINT(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
memory_people
- id — BIGINT
- memory_id — BIGINT — Foreign key → memories.id — NOT NULL
- person_name — VARCHAR(100) — NOT NULL
- person_user_id — BIGINT — Foreign key → users.id
users
- id — BIGINT
- kakao_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- profile_image_url — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP