EpcotCommunity
Tables (5)
comments (Untitled2)
- id (Key) — Primary key — NOT NULL
- login_id (사용자 id(FK)) — int — Foreign key → posts.id — NOT NULL
- posts_id (게시글 id(FK)) — int — Foreign key → users.id — NOT NULL
- content (내용) — clob
- is_deleted (삭제여부) — boolean
- created_at (생성일) — timestamptz
- updated_at (수정일) — timestamptz
- Field
login_history
- id (Key) — int — Primary key — NOT NULL
- login_id (로그인시도한 ID) — varchar(50)
- status (로그인 시도 SUCCESS / FAIL) — varchar(10)
- fail_reason (실패 코드 USER_NOT_FOUND / BAD_PASSWORD) — varchar(50)
- ip_address (시도한 IP (IPv4 / IPv6)) — varchar(45)
- user_agent (브라우저, 클라이언트 정보) — varchar(255)
- fail_count (로그인 누적 실패 횟수) — int
- created_at (시도 일시) — timestamp
- Field
post_files (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- posts_id (게시글 id(FK)) — int — Foreign key → posts.id — NOT NULL
- login_id (사용자 id(FK)) — int — Foreign key → posts.login_id — NOT NULL
- file_name (파일명) — varchar(255)
- download_count (다운횟수) — int
- is_deleted (삭제여부) — boolean
- created_at (생성일) — timestamptz
- file_path (파일 경로) — varchar(500)
- file_size (파일 크기) — int
- Field
posts (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- login_id (사용자 id(FK)) — int — Foreign key → users.id — NOT NULL
- title (제목) — varchar(100)
- content (내용) — clob
- view_count (조회수) — int
- comment_count (댓글 수) — int
- is_deleted (삭제여부) — boolean
- updated (수정)
- created_at (생성일) — timestampptz
- Field
users (Untitled)
- id (Key) — int — Primary key — NOT NULL
- login_id (로그인용 ID) — varchar(50)
- password_hash (암호화된 비밀번호) — varchar(255)
- name (이름) — varchar(20)
- phone (연락처) — varchar(13)
- role (권한 user/admin) — varchar(20)
- status (계정 상태 active/inactive/banned) — varchar(20)
- created_at (생성일) — timestamptz
- updated_at (프로필 수정일) — timestamptz
- Field