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