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)