m:n
awesome_role2permission
id: int primary_keyrole_id: int foreign_keypermission_id: int foreign_key
awesome_role
id: int primary_keyrole_name: varchar(50) not null unique
tag2video
id: small int primary_keytag_id: small int foreign_keyvideo_id: int foreign_key
awesome_tag
1:n
awesome_category2album1
awesome_video
id: int primary_key title: varchar(100) filepath: varchar(128) description: varchar(128) report_cnt: int default 0 like_cnt: int default 0 dislike_cnt: int default 0 collect_cnt: int default 0 upload_time: datetime mode: int foreign_key comment_id: int foreign_key user_id: int foreign_key
awesome_category2album3
awesome_user
id: int primary_keyusername: vharchar(50) not null uniqueemail: varchar(50) not null uniquepassword: varchar(50) not nullrole_id: int foreign_keyallow_notification: boolean default truefollow_notification: boolean default truecomment_notification: boolean default trueexception_notification: boolean default truemail_notification: boolean default truelogin_ip: varchar(128)last_login: datetimeregister_time: datetime
awesome_category2album2
awesome_following
id: int primary_keyfollower: int foreign_key following: int foreign_key
awesome_category2album4
awesome_category5
awesome_category2
awesome_category1
收藏其他用户专辑
awesome_collection
id: int primary_keyuser_id: int foreign_keyvideo_id: int foreign_keycollect_time: datetime
1:1
awesome_tag2album
id: int primary_keytag_id: int foreign_keyalbumy_id: int foreign_key
awesome_category2album5
awesome_category3
awesome_album2video
id: int primary_keyalbumy_id: int foreign_keyvideo_id: int foreign_key
awesome_album
awesome_comment
id: int primary_keycontent: varchar(50) not nullcomment_time: datetimevideo_id: int foreign_keycomment_id: int foreign_key(自引用)report_cnt: int default 0
awesome_category4
创建
video_mode
awesome_album_collection
id: int primary_keyuser_id: int foreign_keyalbumy_id: int foreign_keycollect_time: datetime
收藏其他用户的视频
awesome_permission
id: int primary_keypermission_name: varchar(50)
