bebe_ERD

Tables (13)

age_group (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

block (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • blocker_id (Key2) — Foreign key → member.id — NOT NULL
  • blocked_id (Key3) — Foreign key → member.id — NOT NULL

bulletins (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.id — NOT NULL
  • Field
  • Field2
  • Field3

category_group (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

comments (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • member_id (Key3) — Foreign key → member.id — NOT NULL
  • post_id (Key2) — Foreign key → bulletins.id — NOT NULL
  • Field
  • Field2
  • Field3

community_category (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

event (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • Field
  • Field2

hotdeal (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • title (Field2)
  • contents (Field)
  • send_time (Field3)
  • time_division (Field4)

hotdeal_age (Untitled11)

  • id (Key) — Foreign key → hotdeal.id — NOT NULL
  • id (Key2) — Foreign key → age_group.id — NOT NULL

hotdeal_category (Untitled10)

  • id (Key) — Foreign key → hotdeal.id — NOT NULL
  • id (Key2) — Foreign key → category_group.id — NOT NULL

member (Untitled)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • nickname (Field2)
  • role (Field3)
  • comment_notification (Field5)
  • event_notification (Field8)
  • event_notification_night (Field9)
  • Field10
  • Field11
  • Field12

neighborhood (Untitled12)

  • Key — Primary key — NOT NULL
  • Field
  • Field2

terms (Untitled13)

  • Key — Primary key — NOT NULL
  • Field
  • Field2