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)