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