yanolja-community

Tables (7)

Banner (배너)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • banner_place (배너 위치) — BANNER_PLACE
  • image (이미지) — Image
  • sort_num (정렬 순서) — number

Community (커뮤니티)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • community_type (커뮤니티 유형) — COMMUNITY_TYPE
  • contents (내용) — text
  • user (작성자) — User — Foreign key → User.unique_id — NOT NULL
  • comment_count (댓글 수) — number
  • reation_count (리액션 수) — number

CommunityComment (커뮤니티 댓글)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • created_at (작성일자) — DateTime
  • contents (내용) — text
  • user (유저) — User — Foreign key → User.unique_id — NOT NULL

CommunityMedia (커뮤니티 미디어)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • media_type (미디어 유형) — MEDIA_TYPE
  • sort_num (정렬 순서) — number
  • image (이미지) — Image
  • video_url (비디모 url) — text
  • community (커뮤니티) — Community — Foreign key → Community.unique_id — NOT NULL
  • api_id (api 통신 아이디) — text

Reaction (리액션)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • imo_type (이모지 유형) — IMO_TYPE
  • reaction_type (리액션 유형) — REACTION_TYPE
  • community (커뮤니티) — Community — Foreign key → Community.unique_id — NOT NULL
  • user (유저) — User — Foreign key → User.unique_id — NOT NULL
  • community_comment (댓글) — CommunityComment — Foreign key → CommunityComment.unique_id — NOT NULL

Term (약관)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • term_type (약관 유형) — TERM_TYPE
  • contents (내용) — text

User (유저)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • email (이메일) — text
  • password (비밀번호) — text
  • init_password (초기 비밀번호) — text
  • control_password (조작 비밀번호) — text
  • first_name (성) — text
  • last_name (이름) — text
  • user_state (유저 상태) — USER_STATE
  • user_type (유저 유형) — USER_TYPE
  • login_type (로그인 유형) — LOGIN_TYPE