test

Tables (4)

comment_mst (댓글)

  • comment_code (댓글코드) — INT — Primary key — NOT NULL
  • user_code (작성자) — INT — NOT NULL
  • comment_dtl (댓글 내용) — VARCHAR(50)
  • creation_day (작성일) — DATETIME
  • modifition day (수정일) — DATETIME
  • writer_code (저자코드) — INT — Foreign key → writer_mst.writer_code — NOT NULL
  • text_code (게시글코드) — PK — Foreign key → text_mst.text_code — NOT NULL

text_mst (글)

  • text_code (게시글코드) — INT — Primary key — NOT NULL
  • textuser_code (작성자) — VARCHAR(50) — NOT NULL
  • text_dtl (글 내용) — VARCHAR(50)
  • creation_day (작성일) — DATETIME
  • modifition day (수정일) — DATETIME
  • writer_code (저자코드) — INT — Foreign key → writer_mst.writer_code — NOT NULL

writer_mst (저자)

  • writer_code (저자코드) — INT — Primary key — NOT NULL
  • writer_intro (저자 소개) — VARCHAR(50)
  • creation_day (작성일) — DATETIME
  • modifition day (수정일) — DATETIME — NOT NULL
  • writer_code (저자 이름) — VARCHAR(50) — NOT NULL

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

  • writer_code (저자코드) — INT — Foreign key → writer_mst.writer_code — NOT NULL
  • text_code (게시글코드) — PK — Foreign key → text_mst.text_code — NOT NULL
  • creation_code (작성일) — DATETIME
  • modifition_day (Field) — DATETIME