Test
Tables (6)
Board (Guest Board)
- BoardNumber (number) — int(10) — Primary key — NOT NULL
- Id (id) — varchar2(20) — Foreign key → Member.Id — NOT NULL
- Title (title) — varchar2(50)
- Content (content) — text
- Date (date) — date
- GuestInfo (guestInfo) — varchar2(100)
Board (Admin Board)
- Title (title) — varchar2(50) — Primary key — NOT NULL
- BigSubject (bigSubject) — varchar2(100)
- SmallSubject (smallSubject) — varchar2(100)
- Content (content) — text
Board (Admin Content Board)
- Title (title) — varchar2(50) — Foreign key → Board.Title — NOT NULL
- BigSubject (bigSubject) — varchar2(100)
- SmallSubject (smallSubject) — varchar2(100)
- Content (content) — text
Member (Member Info)
- Id (id) — varchar2(20) — Primary key — NOT NULL
- Password (pw) — varchar2(15)
- Adress (adress) — varchar2(100)
- Email (email) — varchar2(30)
- Name (name) — varchar2(20)
- PhoneNumber (phoneNumber) — int(15)
Member (MemberGrade)
- Number (number) — int(10) — Primary key — NOT NULL
- Id (id) — varchar2(20) — Foreign key → Member.Id — NOT NULL
- Grade (grade) — TINYINT(1)
Member (Search Member)
- Email (email) — varchar2(30) — Primary key — NOT NULL
- Id (id) — varchar2(20) — Foreign key → Member.Id — NOT NULL