v 0.0.1
Tables (7)
attached (첨부파일)
- attachment_id (Key) — Primary key — NOT NULL
- post_id (Field)
- file_url (Field2)
- file_name (Field3)
- file_type (Field4)
- file_size (Field5)
- created_at (Field6)
board (게시판)
- board_id (Key) — Primary key — NOT NULL
- code (Field)
- allow_comment (Field2)
- allow_attachment (Field3)
- category_mode (Field4)
catagories (단과대별)
- category_id (Key) — Primary key — NOT NULL
- board_id (Field)
- namec (Field2)
- code (Field3)
- displayer_order (Field4)
- is_active (Field5)
- Field6
comments (댓글)
- comment_id (Key) — Primary key — NOT NULL
- post_id (Field)
- author_id (Field2)
- content (Field3)
- created_at (Field4)
- deleted_at (Field5)
post (게시글)
- post_id (Key) — Primary key — NOT NULL
- board_id (Field)
- user_id (Field2)
- title (Field3)
- content (Field4)
- is_pinned (Field5)
- view_count (Field6)
- created_at (Field7)
- updated_at (Field8)
- deleted_at (Field9)
post_likes (정렬(최신/좋아요))
- post_id (Key) — Primary key — NOT NULL
- user_id (Field)
- created_at (Field2)
users (사용자/권한)
- user_id (Key) — Primary key — NOT NULL
- login_id (Field)
- password_hash — VARCHAR(100) — 설명 작성(주석(
- name
- major
- student_no
- phone (Field6)
- email (Field7)
- status (Field8)
- role (Field9)
- created_at (Field10)
- last_login_at (Field11)
- social_id (Field12)
- updated_at (Field13)
- Field14 (탈퇴여부)
- Field2