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