KoreaItTest

Tables (8)

auth_mst (회원)

  • auth_code (회원 코드) — PK, AI — Primary key — NOT NULL
  • auth_name (회원 이름) — NOT NULL
  • auth_introduction (회원 소개)
  • create_date (생성일) — NOT NULL
  • update_date (수정일) — NOT NULL

auth_writing (유저-글 연결)

  • auth_code (회원 코드) — PK, AI — Foreign key → auth_mst.auth_code — NOT NULL
  • writing_code (글 번호) — PK, AI — Foreign key → writing_mst.writing_code — NOT NULL

comment_mst (댓글)

  • comment_code (댓글 코드) — PK, AI — Primary key — NOT NULL
  • comment_description (댓글 내용) — NOT NULL
  • create_date (생성일) — NOT NULL
  • update_date (Field3) — NOT NULL
  • writing_code (글 번호2) — PK, AI — Foreign key → writing_mst.writing_code — NOT NULL
  • auth_code (회원 코드) — PK, AI — Foreign key → auth_mst.auth_code — NOT NULL

major_mst (학과)

  • Key (major_code) — PK — Primary key — NOT NULL
  • Field (major_name) — VARCHAR(30) — NOT NULL
  • Field (create_date) — DATETIME
  • Field (update_date) — DATETIME

school_mst (학교)

  • Key (school_code) — PK — Primary key — NOT NULL
  • Field (school_name) — VARCHAR(20) — NOT NULL
  • Field (create_date) — DATETIME
  • Field (update_date) — DATETIME

student_mst (학생)

  • Key (student_code) — PK — Primary key — NOT NULL
  • Field (student_name) — VARCHAR(20) — NOT NULL
  • Field (student_year) — INT — NOT NULL
  • Field (school_code) — INT — NOT NULL
  • Field (major_code) — INT — NOT NULL
  • Field (create_date) — DATETIME
  • Field (update_date) — DATETIME

user_mst (유저)

  • Key (user_code) — PK — Primary key — NOT NULL
  • Field (user_name) — VARCHAR(10) — NOT NULL
  • Field2 (user_email) — VARCHAR(50)
  • Field3 (user_gender) — INT (남자:0, 여자:1)
  • Field4 (user_phone) — VARCHAR(20)
  • Field5 (create_date) — DATETIME
  • Field6 (update_date) — DATETIME

writing_mst (글)

  • writing_code (글 번호) — PK, AI — Primary key — NOT NULL
  • writing_title (글 제목) — NOT NULL
  • writing_description (글 내용)
  • create_date (생성일) — NOT NULL
  • update_date (수정일) — NOT NULL