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