olin

Tables (7)

- (users)

  • user_id (PK) — Primary key — NOT NULL
  • name (Field)
  • platform_id (Field2)
  • platform (Field3)
  • platform_token (Field4)
  • created_at (Field5)
  • updated_at (Field6)

- (group)

  • group_id (PK) — Primary key — NOT NULL
  • user_id (FK) — Foreign key → -.user_id — NOT NULL
  • title (Field3)
  • created_at (Field4)
  • updated_at (Field5)

- (cards)

  • card_id (PK) — Primary key — NOT NULL
  • group_id (FK) — Foreign key → -.group_id — NOT NULL
  • theme_id (FK2) — Foreign key → -.theme_id — NOT NULL
  • content_id (FK3) — Foreign key → -.wedding_id — NOT NULL
  • user_id (FK4) — Foreign key → -.user_id — NOT NULL
  • content_table_name (Field4)
  • title (Field2)
  • created_at (Field)
  • updated_at (Field3)

- (themes)

  • theme_id (PK) — Primary key — NOT NULL
  • theme_name (Field4)
  • theme_cate (Field)
  • file_path (Field2)
  • file_name (Field3)

- (wedding)

  • wedding_id (PK) — Primary key — NOT NULL
  • date (Field2)
  • greeting_title (Field3)
  • greeting_content (Field4)
  • groom_name (Field5)
  • groom_account (Field6)
  • groom_contact (Field7)
  • groom_mother_contact (Field8)
  • groom_father_contact (Field9)
  • bride_name (Field10)
  • bride_account (Field11)
  • bride_mother_contact (Field12)
  • bride_father_contact (Field13)
  • place_name (Field14)
  • place_phone (Field15)
  • place_latitude (Field16)
  • place_longitude (Field17)
  • calender_type (Field21)
  • video_src (Field22)
  • sns_type (Field23)

- (Images)

  • Image_id (PK) — Primary key — NOT NULL
  • content_id (FK) — Foreign key → -.wedding_id — NOT NULL
  • path (Field)
  • content_table_name (Field2)

- (wedding_sub)

  • wedding_sub_id (Key) — Primary key — NOT NULL
  • wedding_id (FK) — Foreign key → -.wedding_id — NOT NULL
  • section (Field)
  • title (Field2)
  • content (Field3)