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