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