GDJ77 semi
Tables (5)
Attach (attach_t)
- Attach No (attach_no) — NUMBER — Primary key — NOT NULL
- Upload Path (upload_path) — VARCHAR2(500)
- Filesystem Name (filesystem_name) — VARCHAR2(500)
- Original Filesystem (original_filesystem) — VARCHAR2(500)
- Download Count (download_count) — NUMBER
- Has Thumbnail (has_thumbnail) — NUMBER
- Board No (board_no) — NUMBER — Foreign key → Board.Board No — NOT NULL
Board (board_t)
- Board No (board_no) — NUMBER — Primary key — NOT NULL
- User No (user_no2) — Int — Foreign key → USER.User No — NOT NULL
- Title (title) — VARCHAR2(1000) — NOT NULL
- Contents (contents) — CLOB
- Hit (hit) — NUMBER — Default 0
- Create Dt (create_dt) — TIMESTAMP
- Modify Dt (modify_dt) — TIMESTAMP
Comment (comment_t)
- Comment No (comment_no) — INT — Primary key — NOT NULL
- User No (user_no2) — Int — Foreign key → USER.User No — NOT NULL
- Contents (contents) — VARCHAR2(2000) — NOT NULL
- Create Dt (create_dt) — TIMESTAMP — NOT NULL
- State (state) — INT — NOT NULL
- Depth (depth) — NUMBER — 원글0, 답글1
- Group No (group_no) — NUMBER
- Board No (board_no2) — NUMBER — Foreign key → Board.Board No — NOT NULL
Schedule (schedule_t)
- ScheduleNo (schedule_no) — NUMBER — Primary key — NOT NULL
- Title (title) — VARCHAR2(50 BYTE)
- Reminder (reminder) — NUMBER
- StartDate (startDate) — DATE
- EndDate (endDate) — DATE
- User No (user_no) — Int — Foreign key → USER.User No — NOT NULL
USER (user_t)
- User No (user_no) — Int — Primary key — NOT NULL
- Email (email) — VARCHAR2(100) — NOT NULL — UNIQUE
- Pw (pw) — VARCHAR2(64)
- Name (name) — VARCHAR2(100)
- Gender (gender) — VARCHAR2(5)
- Mobile (mobile) — VARCHAR2(20)
- Employee Id (employee_id) — VARCHAR2(10)
- Pw Modify Dt (pw_modify_dt) — DATE
- Signup Dt (signup_dt) — DATE