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