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