알메니지연습

테이블 (4)

Copy Of Untitled2 (workplace)

  • Key (workplace_id) — int unsigned auto_increment — 기본 키 — NOT NULL

Untitled (document)

  • Key (document_id) — int unsigned auto_increment — 기본 키 — NOT NULL
  • Key (user_id) — int unsigned — 외래 키 → Untitled.Key — NOT NULL
  • Key (workplace_id) — int unsigend — 외래 키 → Untitled.Key — NOT NULL
  • type — varchar(20) — NOT NULL
  • Field (expire_date) — date — NOT NULL
  • Field (document_image) — blob — NOT NULL

Untitled (user_workplace)

  • Key (user_id) — int unsigned — 외래 키 → Untitled2.Key — NOT NULL
  • Key (workplace_id) — int unsigned — 외래 키 → Copy Of Untitled2.Key — NOT NULL

Untitled2 (user)

  • Key (user_id) — int unsigned auto_increment — 기본 키 — NOT NULL