a
Tables (6)
ServiceCenter (공지사항)
- Service_Post_Num (Key2) — Primary key — NOT NULL
- ID (Key) — Foreign key → User.ID — NOT NULL
- title (Field)
- Content (Field2)
User (유저정보)
- ID (Key) — Primary key — NOT NULL
- PW (Field2)
- NickName (Field4)
- brith_date (Field5)
- sex (Field6)
- Tel (Field7)
- authority (Field)
calendar (캘린더세부일정)
- calendarNum (Key) — Primary key — NOT NULL
- ID(작성자) (Key2) — Foreign key → User.ID — NOT NULL
- date (Field2)
- time (Field3)
- title (Field4)
- content (Field)
- place (Field5)
- Notice (Field6)
- Disclosure_status (Field7)
- Field8
calendarGroupMember (일정참여멤버)
- calendarNum (Key) — Foreign key → calendar.calendarNum — NOT NULL
- ID(참여자) (Key2) — Foreign key → User.ID — NOT NULL
- Comment (Field2)
fashionPost (패션게시글)
- PostNum (Key) — Primary key — NOT NULL
- ID(작성자) (Key2) — Foreign key → User.ID — NOT NULL
- height (Field)
- weight (Field2)
- temperature (Field3)
- writerComment (Field4)
- image (Field5)
userComment (패션게시글댓글)
- comment_num (Key3) — Primary key — NOT NULL
- PostNum (Key) — Foreign key → fashionPost.PostNum — NOT NULL
- ID(작성자) (Key2) — Foreign key → fashionPost.ID(작성자) — NOT NULL
- Comment (Field)
- grade (Field2)
- Upload_Date (Field3)