ai4ose

Tables (6)

friend

  • friend_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id
  • other_id — INT — Foreign key → user.user_id

friend_request

  • request_id — INT — Primary key — NOT NULL
  • receiver_id — INT — Foreign key → user.user_id
  • requester_id — INT — Foreign key → user.user_id

keyword

  • keyword_id — INT — Primary key — NOT NULL
  • name — VARCHAR(512)
  • type — VARCHAR(50)
  • prompt — VARCHAR(2048)

keyword_image

  • keyword_image_id — INT — Primary key — NOT NULL
  • keyword_id — INT — Foreign key → keyword.keyword_id
  • image_url — VARCHAR(255)
  • created_at — TIMESTAMP

user

  • user_id — INT — Primary key — NOT NULL
  • password — VARCHAR(128)
  • nickname — VARCHAR(20) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • regist_date — TIMESTAMP

user_profile_image

  • profile_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • profile_image_url — VARCHAR(512)