webProject

Tables (6)

bloomingDate (1)

  • 지역명 (Field) — 개화날짜

bookmarks (2)

  • userName (Key2) — String — Foreign key → user.userName — NOT NULL
  • festivalName (Key3) — String — Foreign key → festival.festivalName — NOT NULL
  • festivalId (Key32) — String — Foreign key → festival.festivalId — NOT NULL
  • festivalDate (Key4) — String — Foreign key → festival.festivalDate — NOT NULL

comments (3)

  • context (Field) — String — Primary key
  • flowerName (Key2) — String — Foreign key → flower.flowerName — NOT NULL
  • userName (Key3) — String — Foreign key → user.userName — NOT NULL

festival (4)

  • festivalName (Key) — String — Primary key — NOT NULL
  • festivalId (Key3) — String — Primary key — NOT NULL
  • festivalDate (Key4) — String — Primary key — NOT NULL
  • flowerName (Key2) — String — Foreign key → flower.flowerName — NOT NULL
  • location (Field) — String
  • month (Field2) — Int

flower (5)

  • flowerName (Key) — String — Primary key — NOT NULL
  • bloomingTime (Field) — String
  • description (Field2) — String
  • date (Field3) — String

user (6)

  • userName (Key) — String — Primary key — NOT NULL
  • id (Field) — String
  • password (Field2) — String