food_blog_app

Tables (5)

County_categorys (county_categorys)

  • Category_id (category_id) — UUID — Primary key — NOT NULL
  • Post_id (post_id) — UUID — Foreign key → Posts.Post_id — NOT NULL
  • Country (country) — VARCHAR2(10) — NOT NULL
  • Created_at (created_at) — DATE — NOT NULL
  • Created_by (created_by) — VARCHAR2(50) — NOT NULL
  • Modified_at (modified_at) — DATE — NOT NULL
  • Modified_by (modified_by) — VARCHAR2(50) — NOT NULL

Food_types (food_types)

  • Food_id (food_id) — UUID — Primary key — NOT NULL
  • Post_id (post_id) — UUID — Foreign key → Posts.Post_id — NOT NULL
  • Food_type (food_type) — VARCHAR2(10) — NOT NULL
  • Created_at (created_at) — DATE — NOT NULL
  • Created_by (created_by) — VARCHAR2(50) — NOT NULL
  • Modified_at (modified_at) — DATE — NOT NULL
  • Modified_by (modified_by) — VARCHAR2(50) — NOT NULL

Posts

  • Post_id (post_id) — UUID — Primary key — NOT NULL
  • User_id (user_id) — UUID — Foreign key → Users.User_id — NOT NULL
  • Post_title (post_title) — VARCHAR2(50) — NOT NULL
  • Post_details (post_details) — VARCHAR2(1000)
  • Restaurant_address (restaurant_address) — VARCHAR2(1000)
  • Blog_link (blog_link) — VARCHAR2(1000)
  • Map_link (map_link) — VARCHAR2(1000)
  • Created_at (created_at) — DATE — NOT NULL
  • Created_by (created_by) — VARCHAR2(50) — NOT NULL
  • Modified_at (modified_at) — DATE — NOT NULL
  • Modified_by (modified_by) — VARCHAR2(50) — NOT NULL

Review_Stars (review_stars)

  • Review_id (review_id) — UUID — Primary key — NOT NULL
  • Post_id (post_id) — UUID — Foreign key → Posts.Post_id — NOT NULL
  • Total_star (total_star) — NUMBER — NOT NULL
  • Service (service) — NUMBER — NOT NULL
  • Clean (clean) — NUMBER — NOT NULL
  • Price (price) — NUMBER — NOT NULL
  • Amount (amount) — NUMBER — NOT NULL
  • Created_at (created_at) — DATE — NOT NULL
  • Created_by (created_by) — VARCHAR(50) — NOT NULL
  • Modified_at (modified_at) — DATE — NOT NULL
  • Modified_by (modified_by) — VARCHAR(50) — NOT NULL

Users

  • User_id (user_id) — UUID — Primary key — NOT NULL
  • User_Name (user_name) — VARCHAR2(50) — NOT NULL
  • User_pw (user_pw) — VARCHAR2(50) — NOT NULL
  • User_domain (user_domain) — VARCHAR2(50) — NOT NULL