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