개인 프로젝트1
테이블 (7)
attach (Untitled2)
- STORED_FILE_NAME (Key) — varchar(200) — 기본 키 — NOT NULL
- ORIG_FILE_NAME (Field) — varchar(100)
- PROD_ID (Key2) — int(11) — 외래 키 → product.PROD_ID — NOT NULL
- FILE_SIZE (Field2) — decimal(6,1)
- REG_DATE (Field3) — datetime
- UPD_DATE (Field4) — datetime
authority (Untitled7)
- ID (Key) — int(11) — 외래 키 → user.ID — NOT NULL
- AUTHORITY (Field4) — varchar(15)
- REG_DATE (Field6) — datetime
- UPD_DATE (Field8) — datetime
category (Untitled4)
- CATE_CODE (Key) — char(10) — 기본 키 — NOT NULL
- CATE_NAME (Field) — varchar(50)
- UPPER_CATE_CODE (Field2) — char(10)
- CATE_LEVEL (Field3) — int(11)
- REG_DATE (Field6) — datetime
- UPD_DATE (Field8) — datetime
cmm_code (Untitled3)
- CMM_CODE (Key) — char(5) — 기본 키 — NOT NULL
- CMM_CODE_NAME (Field2) — varchar(50)
- REG_DATE (Field6) — datetime
- UPD_DATE (Field8) — datetime
inquiry (Untitled6)
- INQ_NUM (Key) — int(11) — 기본 키 — NOT NULL
- PROD_ID (Key2) — int(11) — 외래 키 → product.PROD_ID — NOT NULL
- EMAIL (Field) — varchar(100)
- NICKNAME (Field2) — varchar(50)
- INQ_CONTENTS (Field3) — varchar(1000)
- REG_DATE (Field4) — datetime
- UPD_DATE (Field5) — datetime
product (Untitled5)
- PROD_ID (Key) — int(11) — 기본 키 — NOT NULL
- USER_ID (Key3) — int(11) — 외래 키 → user.ID — NOT NULL
- CATE_CODE (Key2) — char(10) — 외래 키 → category.CATE_CODE — NOT NULL
- TRADE_CODE (Field12) — char(5)
- STATUS_CODE (Field13) — char(5)
- TITLE (Field14) — varchar(100)
- PRICE (Field7) — int(11)
- DES (Field8) — varchar(2000)
- STOCK (Field9) — int(11)
- REG_DATE (Field4) — datetime
- UPD_DATE (Field6) — datetime
user (Untitled)
- ID (Key) — int(11) — 기본 키 — NOT NULL
- EMAIL (Field) — varchar(100)
- PASSWORD (Field2) — varchar(50)
- NICKNAME (Field3) — varchar(50)
- NAME (Field4) — varchar(20)
- BIRTH (Field5) — varchar(30)
- GENDER (Field6) — char(1)
- PHONE (Field7) — varchar(30)
- ZIPCODE (Field8) — varchar(30)
- ADDR (Field9) — varchar(100)
- SNS_ID (Field10) — varchar(255)
- SNS_TYPE (Field11) — varchar(15)
- REG_DATE (Field12) — datetime
- UPD_DATE (Field13) — datetime