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