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)