어셈블
테이블 (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)