bellbell
Tables (8)
Basic notification (기본알림)
- basic_notification_id (Key3) — Long — Primary key — NOT NULL
- isActivated (Field2) — boolean
- day (Field6) — String
- time (Field7) — String
lunch (점심메뉴알림)
- lunch_id (Key) — Long — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
- basic_notification_id (Key3) — Long — Foreign key → Basic notification.basic_notification_id — NOT NULL
member (사용자)
- member_id (Key) — Long — Primary key — NOT NULL
- email (Field2) — String
- nickname (Field3) — String
menu (메뉴)
- menu_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- lunch_id (Key2) — Long — Foreign key → lunch.lunch_id — NOT NULL
parcel (택배알림)
- parcel_id (Key) — Long — Primary key — NOT NULL
- carrier (Field) — String
- trackingNo (Field2) — String
- member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
tracking_info (추적정보)
- tracking_info_id (Key) — Long — Primary key — NOT NULL
- status (Field) — String
- location (Field2) — String
- time (Field3) — LocalDateTime
- description (Field4) — String
- parcel_id (Key2) — Long — Foreign key → parcel.parcel_id — NOT NULL
usernotification (사용자생성알림)
- user_notification_id (Key) — Long — Primary key — NOT NULL
- content (Field) — String
- time (Field2) — String
- day (Field3) — String
- member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
weather (날씨알림)
- weather_id (Key) — Long — Primary key — NOT NULL
- gridX (Field3) — String
- gridY (Field4) — String
- address (Field5) — String
- member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
- basic_notification_id (Key3) — Long — Foreign key → Basic notification.basic_notification_id — NOT NULL