Yoga_AI_Platfrom

Tables (3)

Info (info)

  • num — int — Primary key — NOT NULL
  • type — char(20)
  • name — char(30)
  • yogaContent — text
  • yogaEffect — text
  • yogaWarning — text
  • yogaImg — text

Member (member)

  • shortId (shorId) — char(100) — Primary key — NOT NULL
  • email — char(30)
  • password — char(20)
  • nickname — char(30)
  • timestamps — datetime

Post (post)

  • author — char(100) — Primary key — NOT NULL
  • shortId (shorId) — char(100) — Foreign key → Member.shortId — NOT NULL
  • title — varchar(100)
  • content — text
  • url — text