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