Table Design in mysql

I need to create one table, Description : I need to create table based on schedule like daily, weekly & monthly,

Columns are like : sno, startdate, enddate, day, scheduletype

For example I'll take weekly data, for my point of view : From sunday to saturday (1 - 7 )Id i create.... So lots of possibilities are creates like (1,2)(1,3) ..(1,2,3)....up to n....this twice possibility only but that will created up to 7 possibility in one.

So how can I store this possibility in mysql database?

If any one have an issue get back to me...

Copyright Notice：Content Author:「RPL」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/2757291/table-design-in-mysql

Products recommended by Amazon

More >>>

SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN

HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs

AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler

Timberland Men's 6-Inch Premium Waterproof Boot

More about “Table Design in mysql” related questions

Mysql table structure design for economic data

Dear all Mysql experts I am very new for Mysql, please providing me some guides here. I have data as shown in picture above, and I am trying to design table structure of Mysql to store those data ...

Show Detail

Mysql table design advice

I have a general question about MySQL database table design. I have a table that contains ~ 650 thousand records, with approximately 100 thousand added per year. The data is requested quite frequen...

Show Detail

Mysql how to design my settings table

I am building a simple cms in php and mysql that will be used for inhouse projects. Now I'm kind of stuck on the the way I should design my mysql table for the settings. There will be multiple proj...

Show Detail

MySQL index design with table partitioning

I have 2 MySQL tables with the following schemas for a web site that's kinda like a magazine. Article (articleId int auto increment , title varchar(100), titleHash guid -- a hash...

Show Detail

How to design a MySql Table for a Tag Cloud?

I have articles on my site, and I would like to add tags which would describe each article, but I'm having problems with design mysql table for tags. I have two ideas: each article would have field "

Show Detail

Optimizing MySQL or table design

I'm puzzled with my SQL homework. I'm not an expert in databases. I'm using MySQL. I have a table named 'news' create table news title text not null, time DATE, ip varchar(15),

Show Detail

Best mysql table design when storing form info?

I am designing a site which has lots of forms. There are about 20 different forms and each form has got its own fields. Therefore i would like to know what the best mysql table design is for storin...

Show Detail

Pivot table with another pivot table design in MySQL and Laravel Elequent

What is better design to join pivot table has another child pivot table. I have award department pivot table with award_id and department_id. Auditor will be assigned to the award in department wi...

Show Detail

General mysql table design advice

i have got some specific data set which regards to the SLA (Service level agreement) for a particular work as follows. here x represents no of hours. once a task completed within given time range

Show Detail

Help with Mysql database design

I have following entities: residential listings, commercial listings, lease listing and featured listings which holds featured properties for each user. The most logical seems to leverage supertype/

Show Detail