sdf
Tables (4)
NFT_profile_image
- nft_image_id — VARCHAR(100) — Primary key — NOT NULL
- nft_url — VARCHAR(100) — NOT NULL
- artist — VARCHAR(100) — NOT NULL
- user_id — VARCHAR(100) — NOT NULL — 지갑 주소
- user_id (user_id2) — VARCHAR(100) — Foreign key → users.user_id — NOT NULL — 지갑 주소
basic_profile_image
- basic_image_id — VARCHAR(100) — Primary key — NOT NULL
- image_url — VARCHAR(100) — NOT NULL
- user_id — VARCHAR(100) — NOT NULL — 지갑 주소
- user_id (user_id2) — VARCHAR(100) — Foreign key → users.user_id — NOT NULL — 지갑 주소
friends
- friend_id — VARCHAR(100) — Primary key — NOT NULL
- to_user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL — 지갑 주소
- from_user_id — VARCHAR(100) — NOT NULL
- is_friend — INT — NOT NULL
users
- user_id — VARCHAR(100) — Primary key — NOT NULL — 지갑 주소
- user_email — VARCHAR(50) — NOT NULL
- user_nickname — VARCHAR(50) — NOT NULL
- country — VARCHAR(3) — NOT NULL
- discord_link — VARCHAR(200)
- twitch_link — VARCHAR(200)
- twitter_link — VARCHAR(200)
- youtube_link — VARCHAR(200)
- game_penalty — INT — 추후 규정 참고
- birth — DATETIME — NOT NULL
- national_flag — VARCHAR(200) — 국가에 따라 저장
- wallet_name — VARCHAR(200) — NOT NULL