bellytime

Tables (14)

Alarm (Untitled14)

  • id (Key) — Primary key — NOT NULL
  • send_id (Field2) — Foreign key → USER.user_id
  • target_id (Field) — Foreign key → USER.user_id
  • alaram_type (Field4) — follow, chatting
  • send_type (Field5) — user or shop
  • target_type (Field6) — user or shop
  • Field7

CHATLOG (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • roomId (Field)
  • content (Field2)
  • createdAt (Field3)
  • modifiedAt (Field4)

CHATTING (Untitled4)

  • chatroomId (Field) — Primary key
  • sub_userId (Field3)
  • publisher (Field4) — Foreign key → USER.user_id
  • content (Field2)

Comment (Untitled9)

  • Comment_id (Field) — Primary key
  • Comment_score (Field2)
  • Comment_date (Field3)
  • Comment_state (Field4)
  • user_id (Field5) — Foreign key → USER.user_id

CoolTimeTable (Untitled13)

  • timetable_id (Key) — Primary key — NOT NULL
  • cooltime_startdate (Field)
  • cooltime_enddate (Field2)
  • gauge (Field3)
  • user_id (Field4) — Foreign key → USER.user_id
  • Food_id (Field5) — Foreign key → Food.Food_id
  • duration (Field6)
  • eat (Field7)

FEED_POST (Untitled2)

  • post_id (Field) — Primary key
  • post_content (Field2)
  • post_img (Field3)
  • shop_Id (Field4) — Foreign key → SHOP.shop_Id
  • post_update_date (Field5)

FOLLOW_SHOP (Untitled10)

  • followshop_id (Key) — Primary key — NOT NULL
  • follow_time (Field3)
  • user_id (Field4) — Foreign key → USER.user_id
  • shop_Id (Field5) — Foreign key → SHOP.shop_Id

FOLLOW_USER (Untitled7)

  • follow_id (Key) — Primary key — NOT NULL
  • host_id (Field)
  • friend_id (Field2)
  • date_time (Field3)
  • user_id (Field4) — Foreign key → USER.user_id

Food (Untitled8)

  • Food_id (Field) — Primary key
  • Food_name (Field2)
  • Food_img (Field3)

RESERAVATION_TIMETABLE (untitle)

  • reservation_timetable_id (Key) — Primary key — NOT NULL
  • res_date (Field)
  • ava_time_start (Field2)
  • ava_time_end (Field3)
  • shop_Id (Field4) — Foreign key → SHOP.shop_Id
  • ava_team (Field5)
  • ava_people (Field6)
  • reservec_check (Field7)

RESERVATION (Untitled5)

  • reservateion_id (Field) — Primary key
  • reserved_date (Field2)
  • reserved_people (Field3)
  • reserved_state (Field4)
  • user_id (Field5) — Foreign key → USER.user_id
  • shop_Id (Field6) — Foreign key → SHOP.shop_Id
  • show_check (Field7)
  • Comment_id (Field8) — Foreign key → Comment.Comment_id

SHOP (Untitled3)

  • shop_Id (Field) — Primary key
  • shop_img (Field2)
  • shop_pass (Field3)
  • shop_name (Field4)
  • shop_altitude (Field5)
  • shop_longtitutde (Field6)
  • shop_address (Field7)
  • shop_runtime (Field8)
  • shop_refund_policy (Field11)

SHOP_MENU (Untitled6)

  • info_id (Key) — Primary key — NOT NULL
  • Food_id (Field) — Foreign key → Food.Food_id
  • menu (Field2)
  • price (Field3)
  • shop_Id (Field6) — Foreign key → SHOP.shop_Id

USER (Untitled)

  • user_id (Field) — Primary key
  • user_pass (Field2)
  • user_nickname (Field3)
  • user_email (Field4)
  • user_phoneNum (Field5)
  • user_profileimg (Field6)
  • user_alarm (Field7)