artist_sns
Tables (5)
Image (이미지)
- image_id (PK) — BIGINT — Primary key — NOT NULL
- user_id (PK2) — BIGINT — Foreign key → User.user_id — NOT NULL
- caption (작품명) — VARCHAR
- explain (작품설명) — VARCHAR
- created_date (생성시간) — DATETIME
- post_image_url (포스트_이미지) — VARCHAR
User (사용자)
- user_id (PK) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR
- email (이메일) — VARCHAR
- password (비밀번호) — VARCHAR
- phone (전화번호) — VARCHAR
- profile_image_url (프로필이미지) — VARCHAR
- created_date (생성시간) — DATETIME
comment (댓글)
- id (PK) — BIGINT — Primary key — NOT NULL
- user_id (PK2) — BIGINT — Foreign key → User.user_id — NOT NULL
- image_id (PK3) — BIGINT — Foreign key → Image.image_id — NOT NULL
- content (내용) — VARCHAR
- created_date (댓글생성시간) — DATETIME
follow (팔로우)
- id (PK) — BIGINT — Primary key — NOT NULL
- from_user_id (PK2) — BIGINT — Foreign key → User.user_id — NOT NULL
- user_id (PK3) — BIGINT — Foreign key → User.user_id — NOT NULL
likes (좋아요)
- like_id (PK) — BIGINT — Primary key — NOT NULL
- user_id (PK2) — BIGINT — Foreign key → User.user_id — NOT NULL
- image_id (PK3) — BIGINT — Foreign key → Image.image_id — NOT NULL
- created_date (좋아요_시간) — DATETIME