ANEMONE

Tables (5)

Category (Untitled4)

  • codename (Key) — char — Primary key — NOT NULL

Consert (Untitled3)

  • ID (Key2) — Primary key — NOT NULL
  • codename (Key) — char — Foreign key → Category.codename — NOT NULL
  • guname (Field) — char
  • title (Field2) — char
  • date (Field3) — date
  • place (Field4) — char
  • org_name (Field5) — char
  • use_trgt (Field6) — char
  • plyaer (Field7) — text
  • program (Field8) — text
  • etc_desc (Field9) — text
  • org_link (Field10) — url
  • main_img (Field11) — url
  • rgstdate (Field12) — date
  • ticket (Field13) — char
  • strtdate (Field14) — date
  • end_date (Field15) — date
  • themecode (Field16) — char
  • lot (Field17) — float
  • lat (Field18) — float
  • is_free (Field19) — char
  • hmpg_addr (Field20)

Like (CopyOfUntitled2)

  • email (Key2) — char — Foreign key → User.email — NOT NULL
  • ID (Key22) — Foreign key → Consert.ID — NOT NULL
  • date (Field) — date

Reserve (Untitled2)

  • email (Key2) — char — Foreign key → User.email — NOT NULL
  • ID (Key22) — Foreign key → Consert.ID — NOT NULL
  • date (Field) — date

User (Untitled)

  • email (Key) — char — Primary key — NOT NULL
  • name (Field) — char
  • password (Field2) — char
  • admin (Field3) — bool