키트웍스 온보딩

테이블 (4)

place

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address (ADDRESS) — VARCHAR(256) — NOT NULL
  • create_at (Field) — DATETIME — NOT NULL
  • modify_at (Field2) — DATETIME
  • delete_at (Field3) — DATETIME

study

  • id — INT — 기본 키 — NOT NULL
  • place_id (PLACE_ID) — INT — 외래 키 → place.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • max_user (MIN_USER) — INT — NOT NULL
  • min_user (MAX_USER) — INT — NOT NULL
  • create_at (Field) — DATETIME — NOT NULL
  • modify_at (Field2) — DATETIME
  • delete_at (Field3) — DATETIME

user

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(128) — NOT NULL
  • create_at — DATETIME — NOT NULL
  • modify_at — DATETIME
  • delete_at — DATETIME

user_study

  • id — INT — 기본 키 — NOT NULL
  • role — INT — NOT NULL
  • user_id — INT — 외래 키 → user.id — NOT NULL
  • study_id — INT — 외래 키 → study.id — NOT NULL
  • create_at — DATETIME — NOT NULL
  • modify_at — DATETIME
  • delete_at — DATETIME