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)