jpademo

Tables (7)

boards

  • id — int(11) — Primary key — NOT NULL
  • boardname — varchar(255)
  • content — varchar(4000)
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL

channels

  • id — int(11) — Primary key — NOT NULL
  • channelId — varchar(255)
  • title — varchar(255)
  • thumbnail — varchar(255)
  • customUrl — varchar(255)
  • lang — varchar(2)
  • category — varchar(255)
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL

customer

  • id — bigint(20) — Primary key — NOT NULL
  • first_name — varchar(255)
  • last_name — varchar(255)

customer_seq

  • next_not_cached_value — bigint(21) — NOT NULL
  • minimum_value — bigint(21) — NOT NULL
  • maximum_value — bigint(21) — NOT NULL
  • start_value — bigint(21) — NOT NULL — start value when sequences is created or value if RESTART is used
  • increment — bigint(21) — NOT NULL — increment value
  • cache_size — bigint(21) — NOT NULL
  • cycle_option — tinyint(1) — NOT NULL — 0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed
  • cycle_count — bigint(21) — NOT NULL — How many cycles have been done

orders

  • id — bigint(20) — Primary key — NOT NULL
  • total_amount — double
  • customer_id — bigint(20) — Foreign key → customer.id — NOT NULL

users

  • id — int(11) — Primary key — NOT NULL
  • username — varchar(255)
  • birthday — datetime
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL

youtubes

  • id — int(11) — Primary key — NOT NULL
  • title — varchar(255)
  • videoId — varchar(255)
  • thumbnail — varchar(255)
  • publishedAt — datetime
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • ChannelId — int(11) — Foreign key → channels.id