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)