enjoytrip

테이블 (8)

Untitled (article_image)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id (article_id) — bigint — 외래 키 → 게시글.id — NOT NULL
  • Field (image_name) — varchar(50) — NOT NULL
  • Field2 (image_uuid) — varchar(50) — NOT NULL
  • Field3 (created_at) — datetime(6) — NOT NULL
  • Field4 (created_by) — varchar(50) — NOT NULL
  • Field5 (updated_at) — datetime(6) — NOT NULL
  • Field (updated_by) — varchar(50) — NOT NULL

member

  • 회원 id (id) — bigint — 기본 키 — NOT NULL
  • asd (email) — varchar(50) — NOT NULL
  • (password) — varchar(50) — NOT NULL
  • name — varchar(50) — NOT NULL
  • Field4 (age) — bigint — NOT NULL
  • Field5 (gender) — varchar(50) — NOT NULL
  • Field (phone_number) — varchar(50) — NOT NULL
  • created_at — datetime(8) — NOT NULL
  • created_by — varchar(50) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • Field (updated_by) — varchar(50) — NOT NULL

message

  • Key (id) — bigint — 기본 키 — NOT NULL
  • 회원 id (member_id) — bigint — 외래 키 → member.회원 id — NOT NULL
  • Key (message_room_id) — bigint — 외래 키 → messageRoom.Key — NOT NULL
  • Field (content) — text — NOT NULL
  • Field2 (created_at) — datetime(6) — NOT NULL
  • Field3 (created_by) — varchar(50) — NOT NULL
  • Field4 (updated_at) — datetim(6) — NOT NULL
  • Field5 (updated_by) — varchar(50) — NOT NULL

messageRoom (message_room)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id (article_id) — bigint — 외래 키 → 게시글.id — NOT NULL
  • 회원 id (sender_id) — bigint — 외래 키 → member.회원 id — NOT NULL
  • 회원 id (receiver_id) — bigint — 외래 키 → member.회원 id — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field2 (created_by) — varchar(50) — NOT NULL
  • Field3 (updated_at) — datetime(6) — NOT NULL
  • Field4 (updated_by) — varchar(50) — NOT NULL

게시글 (article)

  • id — bigint — 기본 키 — NOT NULL
  • 회원 id (member_id) — bigint — 외래 키 → member.회원 id — NOT NULL
  • (title) — varchar(50) — NOT NULL
  • Field3 (content) — varchar(50) — NOT NULL
  • Field6 (views) — bigint — NOT NULL
  • Field7 (atype) — varchar(50) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • Field (created_by) — varchar(50) — NOT NULL
  • Field2 (updated_at) — datetime(6) — NOT NULL
  • updated_by — varchar(50) — NOT NULL

댓글 (comment)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • 회원 id (member_id) — bigint — 외래 키 → member.회원 id — NOT NULL
  • id (article_id) — bigint — 외래 키 → 게시글.id — NOT NULL
  • Field3 (child_id) — bigint — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • created_by — varchar(50) — NOT NULL
  • Field7 (updated_at) — datetime(6) — NOT NULL
  • Field8 (updated_by) — varchar(50) — NOT NULL

좋아요 (like)

  • id — bigint — 기본 키 — NOT NULL
  • 회원 id (member_id) — bigint — 외래 키 → member.회원 id — NOT NULL
  • id (article_id) — bigint — 외래 키 → 게시글.id — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • Field4 (created_by) — varchar(50) — NOT NULL
  • Field5 (updated_at) — datetime(6) — NOT NULL
  • Field6 (updated_by) — varchar(50) — NOT NULL

히스토리 (history)

  • id — bigint — 기본 키 — NOT NULL
  • table_name — varchar(50)
  • Field2 (column_name) — varchar(50)
  • Field3 (action) — varchar(50)
  • (created_at) — datetime(6)
  • Field5 (created_by) — varchar(50)
  • Field (updated_at) — datetime(6)
  • updated_by — varchar(50)