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