koreait_test_0804

Tables (5)

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 → writhing_mst.writing_code — NOT NULL

comment_mst (댓글)

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

user_mst (유저 테이블)

  • user_code (유저 코드) — PK, AI — Primary key — NOT NULL
  • user_id (유저 아이디) — UK, NN
  • user_pw (유저 비밀번호) — NN
  • user_address (유저 주소)
  • user_age (유저나이)
  • user_gender (유저 성별)
  • create_date (생성일)
  • update_date (수정일)

writhing_mst (글)

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