■ 1개의 기본 키를 갖는 테이블 생성하기

------------------------------------------------------------------------------------------------------------------------

 

CREATE TABLE IF NOT EXISTS com_storage

(

    menu_id             char(36)     NOT NULL

   ,id                  char(36)     NOT NULL PRIMARY KEY

   ,name                varchar(100) NOT NULL

   ,file_count          int          NOT NULL

   ,file_size           bigint       NOT NULL

   ,save_directory_path varchar(200) NOT NULL

   ,status_code         char(1)      NOT NULL

   ,description         varchar      NULL

   ,create_id           char(36)     NOT NULL

   ,create_time         timestamp    NOT NULL

   ,update_id           char(36)     NOT NULL

   ,update_time         timestamp    NOT NULL

);

 

------------------------------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG

댓글을 달아 주세요