ERD

Tables (4)

Attachments (Untitled)

  • attach_id (기본키) — NUMBER — Primary key — NOT NULL
  • post_id (글 참조키) — NUMBER — Foreign key → Posts.post_id — NOT NULL
  • org_attach_name (원본파일명) — VARCHAR2(255) — NOT NULL
  • sys_attach_name (서버파일명) — VARCHAR2(100) — NOT NULL
  • attach_path (파일 경로) — VARCHAR2(500) — NOT NULL
  • attach_ext (파일 확장자) — VARCHAR2(20) — NOT NULL
  • attach_size (파일 크기) — NUMBER — NOT NULL
  • uploaded_at (업로드일) — DATE — NOT NULL

Comments (댓글)

  • comment_id (기본키) — NUMBER — Primary key — NOT NULL
  • post_id (글 참조키) — NUMBER — Foreign key → Posts.post_id — NOT NULL
  • user_id (사용자 참조키) — NUMBER — Foreign key → Posts.user_id — NOT NULL
  • content (내용) — VARCHAR2(1000) — NOT NULL
  • created_at (생성일) — DATE — NOT NULL
  • updated_at (수정일) — DATE
  • del_yn (삭제여부) — NUMBER(1) — NOT NULL

Posts (게시글)

  • post_id (기본키) — NUMBER — Primary key — NOT NULL
  • user_id (사용자 참조키) — NUMBER — Foreign key → Users.user_id — NOT NULL
  • title (제목) — VARCHAR2(200) — NOT NULL
  • content (내용) — VARCHAR2(4000) — NOT NULL
  • created_at (생성일) — DATE — NOT NULL
  • updated_at (수정일) — DATE
  • del_yn (삭제여부) — NUMBER(1) — NOT NULL

Users (사용자)

  • user_id (기본키) — NUMBER — Primary key — NOT NULL
  • name (이름(닉네임)) — VARCHAR2(20) — NOT NULL
  • email (이메일) — VARCHAR2(200) — NOT NULL
  • password (비밀번호) — VARCHAR2(60) — NOT NULL
  • phone_number (전화번호) — VARCHAR2(11) — NOT NULL
  • basic_address (주소) — VARCHAR2(200) — NOT NULL
  • detail_address (상세주소) — VARCHAR2(100) — NOT NULL
  • postal_code (우편번호) — VARCHAR2(5) — NOT NULL
  • reg_date (가입일) — DATE — NOT NULL