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