example
Tables (10)
PRODUCT
- prdNo — varchar(10) — NOT NULL
- prdName — varchar(30) — NOT NULL
- prdPrice — int
- prdCompany — varchar(30)
PRODUCT2
- prdNo — varchar(10) — Primary key — NOT NULL
- prdName — varchar(30) — NOT NULL
- prdPrice — int
- prdCompany — varchar(30)
PRODUCT3
- prdNo — varchar(10) — Primary key — NOT NULL
- prdName — varchar(30) — NOT NULL
- prdPrice — int
- prdCompany — varchar(30)
board2
- boardNo — int — NOT NULL
- boardTitle — varchar(30) — NOT NULL
- boardWriter — varchar(20)
- boardContent — varchar(100) — NOT NULL
book
- bookNo — varchar(10) — NOT NULL
- bookName — varchar(30) — NOT NULL
- bookPrice — int
- bookData — date
- pubNo — varchar(10) — NOT NULL
department
- departmentCode — int — NOT NULL
- departmentName — varchar(30) — NOT NULL
scores
- stdNo — varchar(10) — Primary key — NOT NULL
- subId — varchar(10) — Primary key — NOT NULL
- scSc — int
- scGrade — varchar(2)
student
- studentNumber — varchar(20) — NOT NULL
- studentName — varchar(30) — NOT NULL
- studentGrade — int — NOT NULL
- departmentCode — int — NOT NULL
student2
- stdNo — VARCHAR(10) — NOT NULL
- stdName — VARCHAR(30) — NOT NULL
- stdYear — INT
- stdAddress — VARCHAR(50)
- stdBirthday — DATE
- dptNo — VARCHAR(10) — NOT NULL
subjects
- subId — varchar(10) — NOT NULL
- subName — varchar(20) — NOT NULL
- subCredit — int
- proId — varchar(10) — NOT NULL