Waffle

Tables (9)

Copy Of User (CopyOfUntitled)

  • User_Id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • Password (Field2) — String
  • Field3
  • Field4

invitation (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • invitation_image_category_id (Key2) — Foreign key → invitation_image_category.id — NOT NULL
  • title (Field)
  • date (Field2)
  • invation_place (Field3)
  • comment (Field4)
  • invation_code (Field5)
  • updated_at (Field6)
  • created_at (Field7)

invitation_image_category (Untitled8)

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

invitation_member (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • invitation_id (Key2) — BIGINT — Foreign key → invitation.id — NOT NULL
  • User_Id (Key3) — BIGINT — Foreign key → user.User_Id — NOT NULL
  • created_at (Field)
  • updated_at (Field2)

invitation_place_category (Untitled7)

  • id (Key2) — Primary key — NOT NULL
  • invitation_id (Key) — BIGINT — Foreign key → invitation.id — NOT NULL
  • place_category_id (Field)

place (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • invitation_id (Key2) — BIGINT — Foreign key → invitation.id — NOT NULL
  • place_category_id (Key3) — Foreign key → place_category.id — NOT NULL
  • title (Field)
  • comment (Field2)
  • link (Field3)
  • coordinate (좌표)
  • is_decision (Field4) — boolean
  • created_at (Field5)
  • updated_at (Field6)
  • order (Field7)

place_category (Untitled3)

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

place_likes (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • place_id (Key2) — Foreign key → place.id — NOT NULL
  • user_id (Field)
  • updated_at (Field2)
  • created_at (Field3)

user (Untitled)

  • User_Id (Key) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(255)
  • password (Field2) — VARCHAR(255)
  • roles (Field3) — VARCHAR(255)
  • nickname (Field4)
  • created_at (Field5)
  • updated_at (Field6)