Ver 1.0

Tables (6)

Calandar (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • date (Field) — date
  • create_at (Field2) — timestamp
  • update_at (Field3) — timestamp

Diary-Entry (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK2) — bigint — Foreign key → User.id — NOT NULL
  • calandar_id (FK) — bigint — Foreign key → Calandar.id — NOT NULL
  • title (Field5) — varchar(100)
  • content (Field) — string
  • date (Field2) — date
  • update_at (Field3) — timestamp
  • create_at (Field4) — timestamp

Photo (photos)

  • id (Key) — bigint — Primary key — NOT NULL
  • diart_entry_id (FK) — bigint — Foreign key → Diary-Entry.id — NOT NULL
  • url (Field2) — string

Tag (tags)

  • id (Key) — bigint — Primary key — NOT NULL
  • diary_entry_id (FK) — bigint — Foreign key → Diary-Entry.id — NOT NULL
  • type (Field) — string
  • name (Field2) — stging
  • create_at (Field3) — timestamp
  • usage_count (Field4) — bigint

User (users)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field1) — varchar(20)
  • nickname (Field) — varchar(20)
  • email (Field2) — varchar(20)
  • create_at (Field3) — timestamp
  • update_at (Field4) — timestamp

statics

  • id (Key) — bigint — Primary key — NOT NULL
  • tag_id (FK) — bigint — Foreign key → Tag.id — NOT NULL
  • date_range_start (Field) — date
  • date_range_end (Field2) — date