temp_porject

Tables (6)

chat_log (Untitled3)

  • chat_log_id (식별자) — Long — Primary key — NOT NULL
  • chat_room_id (식별자1) — Long — Foreign key → chat_room.chat_room_id — NOT NULL
  • sender_name (보낸이_이름) — String
  • sender_id (보낸이 식별자) — Long
  • text (내용) — String

chat_room (Untitled2)

  • chat_room_id (식별자) — Long — Primary key — NOT NULL
  • title (채팅방 이름) — String

member (회원)

  • member_id (식별자) — Long — Primary key — NOT NULL
  • name (이름) — String
  • sex (성별) — Enum
  • email (이메일) — String
  • password (비밀번호) — String
  • introduce (소개) — String

member_chat (Untitled4)

  • member_chat_id (식별자) — Long — Primary key — NOT NULL
  • member_id (식별자2) — Long — Foreign key → member.member_id — NOT NULL
  • chat_room_id (식별자3) — Long — Foreign key → chat_room.chat_room_id — NOT NULL

member_post (Untitled)

  • member_post_id (식별자) — Long — Primary key — NOT NULL
  • member_id (식별자2) — Long — Foreign key → member.member_id — NOT NULL
  • post_id (식별자3) — Long — Foreign key → post.post_id — NOT NULL
  • chat_room_id (식별자22) — Long — Foreign key → post.chat_room_id — NOT NULL
  • authority (소유권) — Enum

post (게시글)

  • post_id (식별자) — Long — Primary key — NOT NULL
  • chat_room_id (식별자2) — Long — Foreign key → chat_room.chat_room_id — NOT NULL
  • title (제목) — String
  • category (카테고리) — Enum
  • start_date (시작일자) — LocalDateTime
  • end_date (종료일자) — LocalDateTime
  • address (주소) — String
  • recruit_num (모집 인원수) — int
  • current_num (현재 인원수) — int
  • main_text (본문) — String