todo demo

Tables (4)

board (Untitled2)

  • iboard (Key) — bigint — Primary key — NOT NULL
  • iuser (Key2) — bigint — Foreign key → user.iuser — NOT NULL
  • title (Field) — varchar(30)
  • ctnt (Field2) — varchar(50)
  • created_at (Field3) — datetime
  • d_day (Field4) — datetime
  • success (Field5) — char(1)

board_tag (Untitled3)

  • iboard_tag (Key2) — bigint — Primary key — NOT NULL
  • iboard (Key) — bigint — Foreign key → board.iboard — NOT NULL
  • itag (Key3) — bigint — Foreign key → tag.itag — NOT NULL

tag (Untitled4)

  • itag (Key) — bigint — Primary key — NOT NULL
  • tag (Field) — varchar(10)

user (Untitled)

  • iuser (Key) — bigint — Primary key — NOT NULL
  • nm (Field) — varcher(20)
  • pw (Field2) — varchar(100)
  • Field3 — tinyint