database, er-diagram

I didn't download mysql,

so I have to do on web mysql IDE.

 

https://demo.phpmyadmin.net/master-config/public/index.php?route=/table/create&db=sys

---

1. requirements

- If user has a personality test,

they will get type about it (like D)

 

- we will recommend activity

related with type (like reading books)

---

2. data schema

- input db, table, data type, data

---

3. sql

insert into tables

input, output

 

1. make data

- insert



insert into product





2. get data

- select



select product (x)

select from * product (x)

select * from product (o)



select * f

---

4. what you learned from these project

- diffrence with varchar and text

data type	varchar(50)	text
example	nickname, unique key	description
restriction	max length, like 50
storage

 

<summarize about it>

 

- sql query

CREATE TABLE recommended_activities (
    activity_id INT AUTO_INCREMENT PRIMARY KEY,
    activity_name VARCHAR(100),
    description TEXT,
    trait_id INT,
    FOREIGN KEY (trait_id) REFERENCES traits(trait_id)
);

 

- relation

a with b

---

I studied with gpt

https://chatgpt.com/share/674ff1b0-78a8-8005-bd90-831c8ffe8197