개인 프로젝트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