awesome-db-rev2

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)