yumbot
Tables (11)
category_main (Untitled3)
- category_main_pk (Key) — NUMBER — Primary key — NOT NULL
- category_main_name (Field) — VARCHAR2(100)
category_sub (Untitled4)
- category_sub_pk (Key) — NUMBER — Primary key — NOT NULL
- category_main_pk (Key2) — NUMBER — Foreign key → category_main.category_main_pk — NOT NULL
- category_sub_name (Field) — VARCHAR2(100)
hashtag (Untitled9)
- hashtag_pk (Key) — NUMBER — Primary key — NOT NULL
- hashtag_category_pk (Key2) — NUMBER — Foreign key → hashtag_category.hashtag_category_pk — NOT NULL
- hashtag_name (Field) — VARCHAR2(100)
hashtag_category (Untitled10)
- hashtag_category_pk (Key) — NUMBER — Primary key — NOT NULL
- hashtag_category_name (Field) — VARCHAR2(100)
member (Untitled)
- member_pk (Key) — NUMBER — Primary key — NOT NULL
- member_id (Field) — VARCHAR2(100)
- member_pw (Field2) — VARCHAR2(100)
- member_nickname (Field7) — VARCHAR2(100)
- member_phone (Field4) — VARCHAR2(15)
- member_birth (Field5) — DATE
- member_gender (Field3) — VARCHAR2(1)
- member_image_link (Field8) — VARCHAR2(500)
- member_reg_date (Field6) — DATE
restaurant (Untitled2)
- restaurant_pk (Key4) — NUMBER — Primary key — NOT NULL
- category_sub_pk (Key3) — NUMBER — Foreign key → category_sub.category_sub_pk — NOT NULL
- id (Field7) — VARCHAR2(100)
- address_name (Field) — VARCHAR2(1000)
- phone (Field3) — VARCHAR2(100)
- place_name (Field4) — VARCHAR2(200)
- x (Field5) — VARCHAR2(100)
- y (Field6) — VARCHAR2(100)
restaurant_likes (Untitled7)
- restaurant_likes_pk (Key) — NUMBER — Primary key — NOT NULL
- member_pk (Key2) — NUMBER — Foreign key → member.member_pk — NOT NULL
- restaurant_pk (Key4) — NUMBER — Foreign key → restaurant.restaurant_pk — NOT NULL
- restaurant_likes_date (Field) — DATE
review (Untitled5)
- review_pk (Key) — NUMBER — Primary key — NOT NULL
- member_pk (Key2) — NUMBER — Foreign key → member.member_pk — NOT NULL
- restaurant_pk (Key4) — NUMBER — Foreign key → restaurant.restaurant_pk — NOT NULL
- review_content (Field) — VARCHAR2(4000)
- review_neutral_score (Field2) — NUMBER
- review_positive_score (Field3) — NUMBER
- review_negative_score (Field4) — NUMBER
- review_mixed_score (Field5) — NUMBER
- review_reg_date (Field6) — DATE
review_hashtag (Untitled11)
- review_hashtag_pk (Key) — NUMBER — Primary key — NOT NULL
- review_pk (Key2) — NUMBER — Foreign key → review.review_pk — NOT NULL
- hashtag_pk (Key3) — NUMBER — Foreign key → hashtag.hashtag_pk — NOT NULL
review_images (Untitled6)
- review_images_pk (Key3) — NUMBER — Primary key — NOT NULL
- review_pk (Key) — NUMBER — Foreign key → review.review_pk — NOT NULL
- review_images_link (Field) — VARCHAR2(1000)
review_likes (Untitled8)
- review_likes_pk (Key) — NUMBER — Primary key — NOT NULL
- member_pk (Key2) — NUMBER — Foreign key → member.member_pk — NOT NULL
- review_pk (Key3) — NUMBER — Foreign key → review.review_pk — NOT NULL
- review_likes_date (Field) — DATE