방명록

테이블 (5)

commentLike (5)

  • comment_like_seq (Key) — bigint — 기본 키 — NOT NULL
  • comment_wirte_seq (Key3) — bigint — 외래 키 → commentWrite.comment_wirte_seq — NOT NULL
  • created_dt (Field2) — datetime
  • created_id (Field3) — varchar

commentWrite (3)

  • comment_wirte_seq (Key) — bigint — 기본 키 — NOT NULL
  • post_write_seq (Key2) — bigint — 외래 키 → postWrite.post_write_seq — NOT NULL
  • writer_midx (Field) — bigint
  • comment_content (Field2) — varchar
  • like_count (Field3) — int
  • del_yn (Field4) — varchar
  • created_dt (Field5) — datetime
  • created_id (Field6) — varchar
  • updated_dt (Field7) — datetime
  • updated_id (Field8) — varchar

masterWrite (1)

  • midx (Key) — bigint — 기본 키 — NOT NULL
  • master_content (Field) — varchar
  • del_yn (Field2) — varchar
  • created_dt (Field5) — datetime
  • created_id (Field6) — varchar
  • updated_dt (Field7) — datetime
  • created_id (Field8) — varchar

postLike (4)

  • post_like_seq (Key) — bigint — 기본 키 — NOT NULL
  • post_write_seq (Key3) — bigint — 외래 키 → postWrite.post_write_seq — NOT NULL
  • created_dt (Field2) — datetime
  • created_id (Field3) — varchar

postWrite (2)

  • post_write_seq (Key) — bigint — 기본 키 — NOT NULL
  • midx (Field9) — bigint
  • writer_midx (Field) — bigint
  • post_content (Field2) — varchar
  • like_count (Field3) — int
  • del_yn (Field4) — varchar
  • created_dt (Field5) — datetime
  • created_id (Field6) — varchar
  • updated_dt (Field7) — datetime
  • updated_id (Field8) — varchar