본문 바로가기
Back-End/DB

DB 쿼리문

by Jyeoni 2022. 8. 1.

[개발 환경 설정]

개발 툴 : Heidi

개발 언어 : Mysql

show databases;
create database moyeobwa;​
use moyeobwa;

/* ----------- 관리자 db ----------- */
create table admin (
	aId varchar(20) primary key,
	aPw varchar(100),
	aName varchar(20)
);

/* ----------- 사용자 db ----------- */
create table user (
	uId varchar(20) primary key,
	uPw varchar(100) not null,
	uName varchar(20) not null,
	uNickname varchar(30) not null,
	uRegdate date not null
);

/* ----------- 그룹 db ----------- */
create table group (
	gNickname varchar(30) primary key
);

/* ----------- 이미지 저장 db ----------- */
create table picture (
	image_id int not null auto_increment,
    image_type varchar(30) not null,
    image longblob not null,
    image_name varchar(50) not null,
    key image_id (image_id)
);