STUDY

Tables (3)

Untitled (online study)

  • Key (studycode) — varchar(10) — Primary key — NOT NULL
  • Field (title) — text
  • Field2 (place) — text
  • Field (date) — datetime
  • Field (money) — int
  • Field (onoff) — int

Untitled (my study)

  • Key (no) — int — Primary key — NOT NULL
  • Field (study code) — varchar(10)
  • id (member_id) — varchar(45) — Foreign key → member.id — NOT NULL
  • Key (studycode) — varchar(10) — Foreign key → Untitled.Key — NOT NULL

member

  • id — varchar(45) — Primary key — NOT NULL
  • pw — text
  • name — varchar(45)
  • Field2 (kakaoUser) — TINYINT
  • Field (email) — varchar(45)