database table Design

database table Design

Create Tablet_article (article_idinteger, Article_titlevarchar2( $), Article_contentvarchar2( -), CreateDate date, updatedate date)Create TableT_article_index (article_idinteger, index_updatedate date)Insert  intoT_articleValues(1,'Title1','Content1', sysdate,sysdate);Insert  intoT_articleValues(2,'Title2','Content2', To_date ('2015-10-17 22:00:53','YYYY-MM-DD Hh24:mi:ss'), sysdate);Insert  intoT_articleValues(3,'Title3','Content3', Sysdate,to_date ('2015-05-01 22:00:53','YYYY-MM-DD Hh24:mi:ss'));Insert  intoT_articleValues(4,'title4','Content4', Sysdate,to_date ('2015-07-01 22:00:53','YYYY-MM-DD Hh24:mi:ss'));Insert  intoT_articleValues(5,'Title5','content5', Sysdate,to_date ('2015-09-01 22:00:53','YYYY-MM-DD Hh24:mi:ss'));Insert  intoT_article_indexValues(3, Sysdate)Insert  intoT_article_indexValues(5, To_date ('2014-09-01 22:00:53','YYYY-MM-DD Hh24:mi:ss'))Select *  fromt_article;Select *  fromT_article_index;Selecta.article_id,a.article_title,a.article_content,a.updatedate,ai.article_id asArticle_index_id,ai.index_updatedate fromT_article a Left JoinT_article_index AI ona.article_id=ai.article_idOrder  bya.article_idSelecta.article_id,a.article_title,a.article_content,a.updatedate,ai.article_id asArticle_index_id,ai.index_updatedate fromT_article a Left JoinT_article_index AI ona.article_id=ai.article_idwhereai.article_id is NULL orA.updatedate>ai.index_updatedateOrder  bya.article_id Search_stock_article_index

database table Design