team12

Tables (4)

Admin (admin)

  • adminId (admin_id) — Primary key — NOT NULL
  • 실명 (fullname)
  • 유저명 (username)
  • email
  • password

Friends (friends)

  • id — Primary key — NOT NULL
  • requestId (request_id)
  • providerId (provider_id)
  • id (id2) — Foreign key → Users.id — NOT NULL

Messages (messages)

  • id — Primary key — NOT NULL
  • 보낸메세지id (fromu_id)
  • 받은메세지id (tou_id)
  • 보낸날짜 (sent_dt)
  • 읽음 (read)
  • 읽은날짜 (read_dt)
  • 메세지내용 (message_text)
  • id (id2) — Foreign key → Friends.id — NOT NULL
  • id (id3) — Foreign key → Users.id — NOT NULL

Users (users)

  • id — Primary key — NOT NULL
  • username
  • password
  • email
  • date
  • status
  • authenticationTime (authentication_time)
  • userkey
  • ip
  • port
  • randomStatus (random_status)