test

Tables (7)

author_board_relation (저자_게시글_연결테이블)

  • author_code (저자코드) — INT — Foreign key → author_mst.author_code — NOT NULL
  • board_code (글 번호) — INT — Foreign key → board_mst.board_code — NOT NULL
  • create_date (작성일) — DATETIME — NOT NULL
  • update_date (수정일) — DATETIME — NOT NULL

author_mst (저자)

  • author_code (저자코드) — INT — Primary key — NOT NULL
  • author_name (저자 이름) — VARCHAR(50) — NOT NULL
  • author_description (저자 소개) — VARCHAR(100)
  • create_date (작성일) — DATETIME — NOT NULL
  • update_date (수정일) — DATETIME — NOT NULL

board_mst (게시글)

  • board_code (글 번호) — INT — Primary key — NOT NULL
  • board_title (글 제목) — VARCHAR(50) — NOT NULL
  • board_desciption (글 내용) — VARCHAR(500) — NOT NULL
  • create_date (작성일) — DATETIME — NOT NULL
  • update_date (수정일) — DATETIME — NOT NULL

comment_mst (댓글)

  • comment_code (댓글 번호) — INT — Primary key — NOT NULL
  • comment_description (댓글 내용) — VARCHAR(500) — NOT NULL
  • create_date (작성일) — DATETIME
  • update_time (수정일) — DATETIME
  • board_code (글 번호2) — INT — Foreign key → board_mst.board_code — NOT NULL
  • author_code (저자코드) — INT — Foreign key → author_mst.author_code — NOT NULL

major_mst (전공)

  • major_code (전공코드) — INT — Primary key — NOT NULL
  • major_name (전공이름) — VARCHAR(50)) — Primary key — NOT NULL
  • Field

school_mst (학교)

  • school_code (학교번호) — Primary key — NOT NULL
  • user_code (유저코드) — PK, AI — Foreign key → user_mst.user_code — NOT NULL
  • user_on (유저상태) — 1. 휴먼임, 2.휴면아님 — Foreign key → user_mst.user_on — NOT NULL
  • 학교이름 (Field)

user_mst (유저)

  • user_code (유저코드) — INT — Primary key — NOT NULL
  • user_on (유저상태) — INT — Primary key — NOT NULL
  • user_name (유저이름) — VARCHAR(50)