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