The Dream
Tables (9)
Alarm (alarm)
- SEQ (seq) — INT — Primary key — NOT NULL
- Type (type) — VARCHAR(3)
- Title (title) — VARCHAR(255)
- Receipt (receipt) — Boolean
- Register SEQ (reg_seq) — INT — Foreign key → User.SEQ — NOT NULL
Authority (authority)
- SEQ (seq) — INT — Primary key — NOT NULL
- Code (code) — VARCHAR(3)
- Alias (alias) — VARCHAR(30)
Board (board)
- SEQ (seq) — INT — Primary key — NOT NULL
- Type (type) — VARCHAR(3)
- Title (title) — VARCHAR(255)
- Description (description) — Text
- Registration Time (reg_time) — Date
- Receipt (receipt) — INT[]
- File ID (file_id) — VARCHAR(30)
- Important (important) — VARCHAR(1)
- Register SEQ (reg_seq) — INT — Foreign key → User.SEQ — NOT NULL
Class (class)
- SEQ (seq) — INT — Primary key — NOT NULL
- Grade (grade) — VARCHAR(1)
- Class (class) — VARCHAR(30)
Coramdeo (coramdeo)
- SEQ (seq) — INT — Primary key — NOT NULL
- Start Time (start) — Date
- End Time (end) — Date
- Word (word) — VARCHAR(1)[]
- Pray (pray) — VARCHAR(1)[]
- Thanks (thanks) — VARCHAR(1)[]
- English (english) — VARCHAR(1)[]
- Worship (worship) — VARCHAR(1)[]
- Register SEQ (reg_seq) — INT — Foreign key → User.SEQ — NOT NULL
Message (message)
- SEQ (seq) — INT — Primary key — NOT NULL
- Room SEQ (room_seq) — INT — Foreign key → Message Room.SEQ — NOT NULL
- Registration Time (reg_time) — Date
- Description (description) — Text
- Receipt (receipt) — Boolean
- Reservation Time (reservation_time) — Date
- Register SEQ (reg_seq) — INT — Foreign key → User.SEQ — NOT NULL
Message Room (message_room)
- SEQ (seq) — INT — Primary key — NOT NULL
- Sender SEQ (sender_seq) — INT — Foreign key → User.SEQ — NOT NULL
- Recipient SEQ (recipient_seq) — INT — Foreign key → User.SEQ — NOT NULL
Student (student)
- SEQ (seq) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR(30)
- Sex (sex) — VARCHAR(10)
- Birth (birth) — Date
- CLASS_SEQ (class_seq) — INT — Foreign key → Class.SEQ — NOT NULL
User (user)
- SEQ (seq) — INT — Primary key — NOT NULL
- User ID (id) — VARCHAR(30)
- Kakao ID (kakao_id) — VARCHAR(30)
- Password (password) — VARCHAR(255)
- Name (name) — VARCHAR(30)
- Phone (phone) — VARCHAR(30)
- Sex (sex) — VARCHAR(10)
- Birth (birth) — Date
- Approval (approval) — VARCHAR(1)
- Image File ID (image) — VARCHAR(30)
- STUDENT_SEQ (student_seq) — INT — Foreign key → Student.SEQ — NOT NULL
- AUTH_SEQ (auth_seq) — INT — Foreign key → Authority.SEQ — NOT NULL
- CLASS_SEQ (class_seq) — INT — Foreign key → Class.SEQ — NOT NULL