umc
Tables (8)
Copy Of Restaurant (CopyOf식당)
- restaurant_key (식당번호) — NOTNULL — Primary key — NOT NULL
- restaurant_name (식당이름) — NOTNULL
- category (카테고리) — NOTNULL
- restaurant_img (식당사진) — NOTNULL
- restaurant_info (식당소개) — NOTNULL
- video_link (유튜브영상) — NULL
- place (위치) — NOTNULL
- menu (메뉴) — NOTNULL
Copy Of Review (CopyOf리뷰)
- review_id (리뷰번호) — NOTNULL — Primary key — NOT NULL
- user_id (유저번호) — NOTNULL — Foreign key → Copy Of User.user_id — NOT NULL
- restaurant_key (식당번호) — NOTNULL — Foreign key → Copy Of Restaurant.restaurant_key — NOT NULL
- like (가게평가) — NOTNULL
- after_tv (유지중) — NOTNULL
- keyword (키워드) — NOTNULL
- best_menu (최고메뉴) — NOTNULL
Copy Of User (CopyOf유저)
- user_id (유저번호) — NOTNULL — Primary key — NOT NULL
- nickname (닉네임) — NOTNULL
- email (이메일) — NOTNULL
Menu (메뉴)
- menu_id (메뉴번호) — NOTNULL — Primary key — NOT NULL
- ML_id (메뉴리스트번호) — NOTNULL — Foreign key → MenuList.ML_id — NOT NULL
- restaurant_key (식당번호) — NOTNULL — Foreign key → MenuList.restaurant_key — NOT NULL
- menu_img (메뉴사진) — NULL
- menu_name (메뉴이름) — NOTNULL
MenuList (메뉴리스트)
- ML_id (메뉴리스트번호) — NOTNULL — Primary key — NOT NULL
- restaurant_key (식당번호) — NOTNULL — Foreign key → Restaurant.restaurant_key — NOT NULL
Restaurant (식당)
- restaurant_key (식당번호) — NOTNULL — Primary key — NOT NULL
- restaurant_name (식당이름) — NOTNULL
- category (카테고리) — NOTNULL
- restaurant_img (식당사진) — NOTNULL
- restaurant_info (식당소개) — NOTNULL
- video_link (유튜브영상) — NULL
- place (위치) — NOTNULL
Review (리뷰)
- review_id (리뷰번호) — NOTNULL — Primary key — NOT NULL
- user_id (유저번호) — NOTNULL — Foreign key → User.user_id — NOT NULL
- restaurant_key (식당번호) — NOTNULL — Foreign key → Restaurant.restaurant_key — NOT NULL
- like (가게평가) — NOTNULL
- after_tv (유지중) — NOTNULL
- keyword (키워드) — NOTNULL
- best_menu (최고메뉴) — NOTNULL
User (유저)
- user_id (유저번호) — NOTNULL — Primary key — NOT NULL
- nickname (닉네임) — NOTNULL
- email (이메일) — NOTNULL