3rd-proj
Tables (5)
chat_content (유저의 채팅방 채팅 기록)
- chat_content_id (Key1) — Integer — Primary key — NOT NULL
- text (Field4) — varchar
- img (Field5) — bytea
- game_type (Field) — varchar[Enum]
- game_winner_id (Field8) — Integer
- created_date (Field2) — timestamp
- updated_date (Field3) — timestamp
- member_id (Field7) — Integer — Foreign key → member_chatroom.member_id — NOT NULL
- chatroom_id (Field6) — Integer — Foreign key → member_chatroom.chatroom_id — NOT NULL
chatroom (채팅방)
- chatroom_id (Key) — Integer — Primary key — NOT NULL
- title (Field) — varchar
- profile (Field4) — bytea
- created_date (Field3) — timestamp
- updated_date (Field2) — timestamp
friendship (친구여부)
- friendship_id (Key) — Integer — Primary key — NOT NULL
- member_id1 (Key2) — Integer — Foreign key → member.member_id — NOT NULL
- member_id2 (Key3) — Integer — Foreign key → member.member_id — NOT NULL
member (유저)
- member_id (Key) — Integer — Primary key — NOT NULL
- login_id (Field) — varchar
- member_name (Field2) — varchar
- password (Field3) — varchar
- phjone_num (Field4) — varchar
member_chatroom (유저의 채팅방 JOIN 여부)
- member_id (Key) — Integer — Foreign key → member.member_id — NOT NULL
- chatroom_id (Key2) — Integer — Foreign key → chatroom.chatroom_id — NOT NULL