Team1-TU-tech / login

0 stars 0 forks source link

DB SQL 문 완료 #10

Open hamsunwoo opened 1 day ago

hamsunwoo commented 1 day ago
CREATE TABLE LOGIN_TB(
    NUM INT NOT NULL AUTO_INCREMENT,
    FIRSTNAME VARCHAR(50),
    LASTNAME VARCHAR(50),
    ID VARCHAR(50),
    PASSWD VARCHAR(50),
    EMAIL VARCHAR(50),
    GENDER VARCHAR(50),
    BIRTHDAY TIMESTAMP,
    PHONENUMBER VARCHAR(50),
    PRIMARY KEY(NUM)
);