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