DDL 검토 · StdWord

DDL 입력

CREATE TABLE TB_USER (
    TB_USER_SN NUMERIC(10) NOT NULL PRIMARY KEY,
    USER_ID VARCHAR(20) NOT NULL UNIQUE,
    USER_NM VARCHAR(100) NOT NULL,
    EML_ADDR VARCHAR(320),
    USE_YN CHAR(1) NOT NULL CHECK (USE_YN IN ('Y', 'N')),
    REG_DT DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    RGTR_ID VARCHAR(20) NOT NULL,
    MDFCN_DT DATETIME,
    MDFR_ID VARCHAR(20)
);
CREATE UNIQUE INDEX UX_TB_USER_USER_ID ON TB_USER(USER_ID);

분석 결과

DDL 검증 대기