MyPet

Tables (5)

calendar

  • id — int — Primary key — NOT NULL — primary key, auto increment
  • userId — int — Foreign key → user.id — NOT NULL
  • userDogId — int — Foreign key → userdog.id — NOT NULL
  • walkDistance — int — NOT NULL
  • content — varchar(256) — NOT NULL
  • diaryImagePath — varchar(512)
  • startDate — date — NOT NULL
  • endDate — date — NOT NULL
  • createdAt — timestamp — DEFAULT_GENERATED
  • updatedAt — timestamp — DEFAULT_GENERATED

dogkind

  • id — int — Primary key — NOT NULL — primary key, auto increment
  • dogKind — varchar(256) — NOT NULL
  • dogKindImagePath — varchar(512)
  • features — text — NOT NULL
  • createdAt — timestamp — DEFAULT_GENERATED
  • updatedAt — timestamp — DEFAULT_GENERATED

post

  • id — int — Primary key — NOT NULL — primary key, auto increment
  • userId — int — Foreign key → user.id — NOT NULL
  • subject — varchar(256) — NOT NULL
  • content — text — NOT NULL
  • postImagePath — varchar(512)
  • createdAt — timestamp — DEFAULT_GENERATED
  • updatedAt — timestamp — DEFAULT_GENERATED

user

  • id — int — Primary key — NOT NULL — primary key, auto increment
  • loginId — varchar(256) — NOT NULL
  • password — varchar(256) — NOT NULL
  • name — varchar(256) — NOT NULL
  • email — varchar(256) — NOT NULL
  • address — varchar(256) — NOT NULL
  • phoneNumber — varchar(32) — NOT NULL
  • profileImagePath — varchar(512)
  • createdAt — timestamp — DEFAULT_GENERATED
  • updatedAt — timestamp — DEFAULT_GENERATED

userdog

  • id — int — Primary key — NOT NULL — primary key, auto increment
  • userid — int — Foreign key → user.id — NOT NULL
  • dogName — varchar(256) — NOT NULL
  • dogAge — int — NOT NULL
  • dogWeight — int — NOT NULL
  • dogKindId — int — Foreign key → dogkind.id — NOT NULL
  • dogProfileImagePath — varchar(256)
  • createdAt — timestamp — DEFAULT_GENERATED
  • updatedAt — timestamp — DEFAULT_GENERATED