SMYC

Tables (11)

Admin (Untitled10)

  • id (Key) — varchar(30) — Primary key — NOT NULL
  • pw (Field)

Advisor (Untitled7)

  • no (Key) — number — Primary key — NOT NULL
  • b_no (Key2) — number — Foreign key → Board.no — NOT NULL
  • email (Key3) — varchar(100) — Foreign key → Member.email — NOT NULL
  • title (Field) — varchar(100)
  • contents (Field2) — varchar(1000)
  • top (Field3) — varchar(100)
  • pants (Field4) — varchar(100)
  • shose (Field5) — varchar(100)
  • acc (Field6) — varchar(100)
  • choice (Field7) — varchar(2)
  • writeDate (Field8) — date
  • nickName (Field9) — varchar(100)

Board (Untitled6)

  • no (Key) — number — Primary key — NOT NULL
  • email (Key2) — varchar(100) — Foreign key → Member.email — NOT NULL
  • c_no (Key3) — number — Foreign key → Coordi.no — NOT NULL
  • category (Field) — varchar(2)
  • nickName (Field2) — varchar(100)
  • title (Field3) — varchar(100)
  • contents (Field4) — varchar(100)
  • writeDate (Field5) — date
  • view (Field7) — number

Board_like (Untitled9)

  • no (Key) — number — Primary key — NOT NULL
  • b_no (Key2) — number — Foreign key → Board.no — NOT NULL
  • email (Key3) — varchar(100) — Foreign key → Member.email — NOT NULL
  • category (Field) — varchar(2)

Closet (Untitled2)

  • no (Key) — number — Primary key — NOT NULL
  • email (Key2) — varchar(100) — Foreign key → Member.email — NOT NULL
  • name (Field) — varchar(100)
  • memo (Field2) — varchar(300)
  • public (Field3) — varchar(2)

Comment (Untitled8)

  • no (Key) — number — Primary key — NOT NULL
  • no (Key2) — number — Foreign key → Board.no — NOT NULL
  • email (Key3) — varchar(100) — Foreign key → Member.email — NOT NULL
  • nickName (Field) — varchar(100)
  • contents (Field2) — varchar(1000)
  • writeDate (Field3)

Coordi (Untitled5)

  • no (Key) — number — Primary key — NOT NULL
  • email (Key2) — varchar(100) — Foreign key → Member.email — NOT NULL
  • name (Field) — varchar(100)
  • thumbNail (Field2) — varchar(100)
  • top (Field3) — varchar(100)
  • pants (Field4) — varchar(100)
  • shose (Field5) — varchar(100)
  • acc (Field6) — varchar(100)
  • season (Field7) — number
  • memo (Field8) — varchar(1000)
  • writeDate (Field9)

Dress (Untitled3)

  • no (Key) — number — Primary key — NOT NULL
  • email (Key2) — varchar(100) — Foreign key → Member.email — NOT NULL
  • c_no (Key3) — number — Foreign key → Closet.no — NOT NULL
  • name (Field) — varchar(100)
  • category (Field2) — varchar(100)
  • public (Field3) — varchar(2)
  • season (Field4) — number
  • writeDate (Field5) — date
  • memo (Field6) — varchar(300)
  • price (Field7) — varchar(100)
  • buyDate (Field8)

Dress_imgs (Untitled4)

  • no (Key) — number — Primary key — NOT NULL
  • d_no (Key2) — number — Foreign key → Dress.no — NOT NULL
  • email (Key22) — varchar(100) — Foreign key → Dress.email — NOT NULL
  • oriName (Field) — varchar(100)
  • sysName (Field2) — varchar(100)
  • path (Field3)

Member (Untitled)

  • email (Key) — varchar(100) — Primary key — NOT NULL
  • pw (Field) — varchar(64)
  • name (Field2) — varchar(30)
  • nickname (Field3) — varchar(100)
  • gender (Field4) — varchar(2)
  • joinDate (Field5) — date
  • ban (Field6) — varchar(2)
  • phone (Field7) — varchar(11)

Visitor (Untitled11)

  • no (Key) — number — Primary key — NOT NULL
  • ipAddr (Field) — varchar(100)
  • visiteDate (Field2)