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