DbModel

Tables (9)

Budget

  • budget_id — INT — Primary key
  • room_id — INT — Foreign key → Schedule.room_id — NOT NULL
  • schedule_id — INT — Foreign key → Schedule.schedule_id
  • item_name — VARCHAR(20) — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • description — VARCHAR(50)

ChatRoom

  • room_id — INT — Primary key — NOT NULL
  • room_name — VARCHAR(20) — NOT NULL
  • created_at (created time) — TIMESTAMP

FriendList

  • flist_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • friend_id — INT

InviteCode

  • code_id — INT — Primary key — NOT NULL
  • room_id — INT — Foreign key → ChatRoom.room_id — NOT NULL
  • code — VARCHAR(100) — NOT NULL
  • expiration_date — DATE — NOT NULL

Message

  • message_id — INT — Primary key — NOT NULL
  • room_id (room_id2) — INT — Foreign key → ChatRoom.room_id — NOT NULL
  • room_id — INT
  • user_id — INT
  • content — TEXT
  • created_at — TIMESTAMP

Photo

  • photo_id — INT — Primary key — NOT NULL
  • room_id — INT — Foreign key → ChatRoom.room_id — NOT NULL
  • file_path — VARCHAR(255)
  • uploaded_at (uploaded_time) — TIMESTAMP

RoomMember

  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • room_id — INT — Foreign key → ChatRoom.room_id — NOT NULL

Schedule

  • schedule_id — INT — Primary key — NOT NULL
  • room_id — INT — Foreign key → ChatRoom.room_id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • date — SMALLDATETIME — NOT NULL
  • description — VARCHAR(50)
  • place — VARCHAR(20)

User

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • profile_image — VARCHAR(255)
  • friends — INT