umc_week1

Tables (3)

member (Untitled)

  • id — BIGINT — Primary key
  • email (VARCHAR(255)) — NN — NOT NULL
  • nickname (VARCHAR(50)) — NN
  • created_at (DATETIME) — NN
  • updated_at (Field) — NN
  • deleted_at (Field2)

member (Untitled2)

  • Logical Name (Physical Name) — Type — Primary key — NOT NULL
  • id — BIGINT
  • email — VARCHAR(255)
  • nickname — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME — NOT NULL

social_account (Untitled3)

  • Logical Name (Physical Name) — Type — Primary key — NOT NULL
  • id — BIGINT
  • member_id — BIGINT
  • provider — VARCHAR(20)
  • provider_user_id — VARCHAR(255)
  • created_at — DATETIME