artisteb_Hejow_version1

Tables (21)

DM

  • id — bigint(20) — Primary key — NOT NULL
  • avatar_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • created_at — datetime — NOT NULL
  • status — int(4) — NOT NULL

avatar

  • id — bigint(20) — Primary key — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • bio — varchar(255)
  • picture — TEXT(255)

board

  • id — bigint(20) — Primary key — NOT NULL
  • category — varchar(20) — NOT NULL

comment_comment

  • id — bigint(20) — Primary key — NOT NULL
  • avatar_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • comment_id — bigint(20) — Foreign key → post_comment.id — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • status — int(4) — NOT NULL

file

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • org_name — varchar(20) — NOT NULL
  • size(byte) — int(11) — NOT NULL
  • type — varchar(20) — NOT NULL
  • width — int(11) — NOT NULL
  • height — int(11) — NOT NULL
  • path — varchar(20) — NOT NULL — 굳이..?

follower

  • follower_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • created_at — datetime — NOT NULL

following

  • following_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • created_at — datetime — NOT NULL

messages

  • id — bigint(20) — Primary key — NOT NULL
  • avatar_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • DM_id — bigint(20) — Foreign key → DM.id — NOT NULL
  • created_at — datetime — NOT NULL
  • content — text
  • status — int(4) — NOT NULL

msg_file

  • msg_id — bigint(20) — Foreign key → messages.id — NOT NULL
  • file_id — bigint(20) — Foreign key → file.id — NOT NULL

oauth

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • access_token — varchar(255) — NOT NULL
  • provider — varchar(255) — NOT NULL

post

  • id — bigint(20) — Primary key — NOT NULL
  • avatar_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • board_id — bigint(20) — Foreign key → board.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • status — int(4) — NOT NULL

post_comment

  • id — bigint(20) — Primary key — NOT NULL
  • avatar_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • post_id — bigint(20) — Foreign key → post.id — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • status — int(4) — NOT NULL

post_content

  • post_id — bigint(20) — Foreign key → post.id — NOT NULL
  • content — longtext — NOT NULL

post_file

  • post_id — bigint(20) — Foreign key → post.id — NOT NULL
  • file_id — bigint(20) — Foreign key → file.id — NOT NULL

post_like

  • post_id — bigint(20) — Foreign key → post.id — NOT NULL
  • like_user_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • created_at — datetime — NOT NULL

post_tag

  • post_id — bigint(20) — Foreign key → post.id — NOT NULL
  • tag_id — bigint(20) — Foreign key → tag.id — NOT NULL

role

  • id — bigint(20) — Primary key — NOT NULL
  • position — varchar(20) — NOT NULL

tag

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • description — varchar(255)
  • created_at — datetime — NOT NULL

user

  • id — bigint(20) — Primary key — NOT NULL
  • avatar_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • user_info_id — bigint(20) — Foreign key → user_info.id — NOT NULL
  • login_id — varchar(20) — NOT NULL
  • password — varchar(30) — NOT NULL
  • created — dateime — NOT NULL
  • last_updated — datetime — NOT NULL
  • status — int(4) — NOT NULL — 유저의 상태 1. 활성 2. 비활성 3. 정지 - 일시? 영구? 4. 휴면

user_info

  • id — bigint(20) — Primary key — NOT NULL
  • first_name — varchar(20) — NOT NULL
  • last_name — varchar(20) — NOT NULL
  • age — int(4) — NOT NULL
  • genre — int(4) — 장르 1. 힙합 2. R&B 3. 프로듀싱 4. 작곡
  • belong — varchar(20)
  • birth — datetime — NOT NULL
  • email — varchar(20)
  • number — varchar(20) — NOT NULL

user_role

  • role_id — bigint(20) — Foreign key → role.id — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL