SwimSiwon

Tables (4)

ChatLog (Untitled4)

  • id (PK) — int — Primary key — NOT NULL
  • user_id (FK) — int — Foreign key → User.id — NOT NULL
  • message_from (Field) — enum
  • message_content (Field2) — text
  • created_at (default) — datetime

Progress (Untitled3)

  • id (PK) — int — Primary key — NOT NULL
  • user_id (FK) — int — Foreign key → User.id — NOT NULL
  • style (enum)
  • level (default) — datetime

Swimdiary (Untitled2)

  • id (PK) — int — Primary key — NOT NULL
  • date (Date) — Date
  • content (text) — text
  • mood (varchar(50))
  • created_at (datetime)
  • user_id (FK) — int — Foreign key → User.id — NOT NULL

User (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • Email (Unique) — char
  • pw (Field2) — char
  • nickname (Field3) — char
  • created_at (Field4) — date