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