DB
Tables (9)
Coupon (Untitled7)
- Key — Primary key — NOT NULL
- user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
- name (Field)
- discountRate (Field2)
- category (Field3)
- content (Field4)
- createdDate (Field5)
- modifiedDate (Field6)
- expiredDate (Field7)
Diary (Untitled3)
- diary_id (Key) — Primary key — NOT NULL
- user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
- title (Field) — bigint(20)
- createdDate (Field2) — timestamp
- modifiedDate (Field3) — timestamp
- content (Field4) — varchar(255)
- picture (Field5)
Like (Untitled6)
- user_id (Key) — bigint(20) — Foreign key → User.user_id — NOT NULL
- place_id (Key2) — Foreign key → Place.place_id — NOT NULL
- createdDate (Field)
- modifiedDate (Field2)
- Y/N (Field3)
- likeCnt (Field4)
Pet (Untitled2)
- pet_id (PK) — bigint(20) — Primary key — NOT NULL
- user_id (Key) — bigint(20) — Foreign key → User.user_id — NOT NULL
- name (Field) — varchar(255)
- species (Field2) — varchar(255)
- age (Field3) — bigint(20)
- content (Field4) — varchar(255)
- createdDate (Field5)
- modifiedDate (Field6)
Place (Untitled4)
- place_id (Key) — Primary key — NOT NULL
- diary_id (Key2) — Foreign key → Diary.diary_id — NOT NULL
- address (Field)
- hour (Field2)
- name (Field3)
- category (Field4)
- picture (Field5)
- createdDate (Field6)
- modifiedDate (Field7)
Reservation (Untitled8)
- reservation_id (Key) — Primary key — NOT NULL
- user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
- reservedDate (Field)
- price (Field2)
- createdDate (Field3)
- modifiedDate (Field4)
Review (Untitled5)
- id (Key) — Primary key — NOT NULL
- rating (Field)
- content (Field2)
- picture (Field3)
- createdDate (Field4)
- modifiedDate (Field5)
- user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
- place_id (Key3) — Foreign key → Place.place_id — NOT NULL
User (Untitled)
- user_id (Key) — bigint(20) — Primary key — NOT NULL
- name (Field) — varchar(255)
- phone_number (Field2) — bigint(20)
- address (Field3) — varchar(255)
- email (Field4) — varchar(255)
- createdDate (Field5)
- modifiedDate (Field6)