handbookfinal

Tables (16)

bookmark

  • book_num — INT — Primary key — NOT NULL
  • owner_num — INT — Foreign key → user.user_num
  • bfriend_num — INT — Foreign key → user.user_num
  • INDEX — `owner_num`
  • INDEX — `bfriend_num`

clikealarm

  • clikeal_num — INT — Primary key — NOT NULL
  • receiver_num — INT — Foreign key → user.user_num
  • sender_num — INT — Foreign key → user.user_num
  • comment_num — INT — Foreign key → comment.comment_num
  • alarmtime — DATETIME
  • INDEX — `receiver_num`
  • INDEX — `sender_num`
  • INDEX — `comment_num`

comment

  • comment_num — INT — Primary key — NOT NULL
  • user_num — INT — Foreign key → user.user_num
  • post_num — INT — Foreign key → post.post_num
  • guest_num — INT — Foreign key → guestbook.guest_num
  • comment_content — VARCHAR(200)
  • comment_group — INT
  • comment_step — INT
  • comment_level — INT
  • comment_writeday — DATETIME
  • INDEX — `user_num`
  • INDEX — `post_num`
  • INDEX — `comment_ibfk_3`

commentalarm

  • commental_num — INT — Primary key — NOT NULL
  • receiver_num — INT — Foreign key → user.user_num
  • comment_num — INT — Foreign key → comment.comment_num
  • sender_num — INT — Foreign key → user.user_num
  • comment_content — VARCHAR(200)
  • comment_writeday — DATETIME
  • INDEX — `receiver_num`
  • INDEX — `sender_num`
  • INDEX — `comment_num`

commentlike

  • clike_num — INT — Primary key — NOT NULL
  • user_num — INT — Foreign key → user.user_num
  • comment_num — INT — Foreign key → comment.comment_num
  • INDEX — `user_num`
  • INDEX — `comment_num`

followalarm

  • followal_num — INT — Primary key — NOT NULL
  • receiver_num — INT — Foreign key → user.user_num
  • sender_num — INT — Foreign key → user.user_num
  • alarmtime — DATETIME
  • INDEX — `receiver_num`
  • INDEX — `sender_num`

following

  • fing_num — INT — Primary key — NOT NULL
  • from_user — INT — Foreign key → user.user_num
  • to_user — INT — Foreign key → user.user_num
  • INDEX — `from_user`
  • INDEX — `to_user`

guestbook

  • guest_num — INT — Primary key — NOT NULL
  • write_num — INT — Foreign key → user.user_num
  • owner_num — INT — Foreign key → user.user_num
  • guest_content — VARCHAR(300)
  • guest_file — VARCHAR(1000)
  • guest_access — VARCHAR(20)
  • guest_writeday — DATETIME
  • INDEX — `guestbook_ibfk_1`
  • INDEX — `guestbook_ibfk_2`

guestbooklike

  • glike_num — INT — Primary key — NOT NULL
  • user_num — INT — Foreign key → user.user_num
  • guest_num — INT — Foreign key → guestbook.guest_num
  • INDEX — `user_num`
  • INDEX — `fk_guestbooklike_guest`

message

  • mess_num — INT — Primary key — NOT NULL
  • sender_num — INT — Foreign key → user.user_num
  • receiver_num — INT — Foreign key → user.user_num
  • mess_group — INT
  • mess_content — VARCHAR(1000)
  • mess_writeday — DATETIME
  • INDEX — `sender_num`
  • INDEX — `receiver_num`

messagealarm

  • messal_num — INT — Primary key — NOT NULL
  • receiver_num — INT — Foreign key → user.user_num
  • sender_num — INT — Foreign key → user.user_num
  • mess_group — INT
  • chkcount — INT
  • INDEX — `user1_num`
  • INDEX — `user2_num`

plikealarm

  • plikeal_num — INT — Primary key — NOT NULL
  • receiver_num — INT — Foreign key → user.user_num
  • sender_num — INT — Foreign key → user.user_num
  • post_num — INT — Foreign key → post.post_num
  • guest_num — INT — Foreign key → guestbook.guest_num
  • alarmtime — DATETIME
  • INDEX — `receiver_num`
  • INDEX — `sender_num`
  • INDEX — `post_num`
  • INDEX — `guest_num`

post

  • post_num — INT — Primary key — NOT NULL
  • user_num — INT — Foreign key → user.user_num
  • post_content — VARCHAR(300)
  • post_file — VARCHAR(1000)
  • post_access — VARCHAR(20)
  • post_writeday — DATETIME
  • INDEX — `user_num`

postalarm

  • postal_num — INT — Primary key — NOT NULL
  • receiver_num — INT — Foreign key → user.user_num
  • sender_num — INT — Foreign key → user.user_num
  • post_num — INT — Foreign key → post.post_num
  • guest_num — INT — Foreign key → guestbook.guest_num
  • comment_content — VARCHAR(200)
  • comment_writeday — DATETIME
  • INDEX — `receiver_num`
  • INDEX — `sender_num`
  • INDEX — `post_num`
  • INDEX — `guest_num`

postlike

  • plike_num — INT — Primary key — NOT NULL
  • user_num — INT — Foreign key → user.user_num
  • post_num — INT — Foreign key → post.post_num
  • INDEX — `user_num`
  • INDEX — `post_num`

user

  • user_num — INT — Primary key — NOT NULL
  • user_id — VARCHAR(20)
  • user_pass — VARCHAR(100)
  • user_name — VARCHAR(50)
  • user_hp — VARCHAR(20)
  • user_addr — VARCHAR(200)
  • user_email — VARCHAR(100)
  • user_gender — VARCHAR(20)
  • user_birth — VARCHAR(20)
  • user_joindate — DATETIME
  • user_photo — VARCHAR(100)
  • user_description — VARCHAR(500)
  • user_cover — VARCHAR(100)
  • mail_auth — INT
  • mail_key — VARCHAR(50)