어셈블

테이블 (9)

assembleInfo (Untitled8)

  • memerNo (Key) — 외래 키 → member.memerNo — NOT NULL
  • id (Field)
  • assembleName (Field2)
  • email (Field3)
  • password (Field4)
  • admin (Field5)

category (Untitled5)

  • categoryNum (Key3) — 기본 키 — NOT NULL
  • memerNo (Key) — 외래 키 → member.memerNo — NOT NULL
  • gruopNo (Key2) — 외래 키 → group.gruopNo — NOT NULL

file (Untitled10)

  • bno (Key) — number(5) — 외래 키 → groupboard.bno — NOT NULL
  • memerNo (Key2) — 외래 키 → groupboard.memerNo — NOT NULL
  • file (Field) — varchar(50)

group (Untitled2)

  • gruopNo (Key) — 기본 키 — NOT NULL
  • manager (Field2) — varchar(20)
  • groupimg (Field5) — varchar(100)
  • gruopName (Field)

groupboard (Untitled)

  • bno (Key) — number(5) — 기본 키 — NOT NULL
  • memerNo (Key2) — 외래 키 → member.memerNo — NOT NULL
  • date (Field3) — date
  • contents (Field4) — varchar(3000)
  • recommend (Field5) — varchar(500)
  • notice (Field6) — number(2)
  • like (Field9) — number(3)
  • hate (Filed10) — number(3)
  • book (Field) — number(1)
  • requestboolean (Field2) — number(1)

member (Untitled4)

  • memerNo (Key) — 기본 키 — NOT NULL

member sub (Untitled7)

  • memerNo (Key) — 외래 키 → member.memerNo — NOT NULL
  • phone (Field) — number(11)
  • team (Field2) — varchar(20)
  • profileimg (Field3) — varchar(50)
  • grade (Field4) — varchar(20)
  • date (Field5) — date

recomment (Untitled3)

  • bno (Key2) — number(5) — 외래 키 → groupboard.bno — NOT NULL
  • memerNo (Key22) — 외래 키 → groupboard.memerNo — NOT NULL
  • reno (Field) — number(5)
  • redate (Field3) — date
  • like (Field4) — number(3)
  • hate (Field5) — number(3)
  • reid (Field2) — varchar(30)

requestboard (Untitled11)

  • bno (Key) — number(5) — 외래 키 → groupboard.bno — NOT NULL
  • memerNo (Key2) — 외래 키 → groupboard.memerNo — NOT NULL
  • status (Field) — number(1)
  • responseid (Field3) — varchar(30)