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)