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