ewewe

Tables (15)

Acquisition

  • acquisition_id — VARCHAR(50) — Primary key — NOT NULL
  • acquisition_name — VARCHAR(255) — NOT NULL
  • acquisition_detail — TEXT
  • acquisition_found_date — DATETIME
  • acquisition_image — VARCHAR(500)
  • acquisition_state — ENUM('KEEPING', 'HANDED_OVER', 'DISPOSED') — NOT NULL
  • acquisition_enter_date — DATETIME — NOT NULL
  • laf_id — VARCHAR(50) — Foreign key → LostAndFound.laf_id — NOT NULL
  • place_id — VARCHAR(50) — Foreign key → Place.place_id — NOT NULL
  • minor_category_id — VARCHAR(50) — Foreign key → MinorCategory.minor_category_id — NOT NULL
  • user_email — VARCHAR(255) — Foreign key → NormalUser.user_email — NOT NULL

Admin

  • admin_id — VARCHAR(50) — Primary key — NOT NULL
  • admin_pw — VARCHAR(255) — NOT NULL

Agreement

  • agreement_id — VARCHAR(50) — Primary key — NOT NULL
  • agreement_name — VARCHAR(255) — NOT NULL
  • agreement_detail — TEXT

Class

  • class_id — VARCHAR(50) — Primary key — NOT NULL
  • grade — INT — NOT NULL
  • classd — VARCHAR(50) — NOT NULL
  • department_id — VARCHAR(50) — Foreign key → Department.department_id — NOT NULL

Department

  • department_id — VARCHAR(50) — Primary key — NOT NULL
  • department_name — VARCHAR(100) — NOT NULL

LostAndFound

  • laf_id — VARCHAR(50) — Primary key — NOT NULL
  • laf_name — VARCHAR(100) — NOT NULL
  • place_id — VARCHAR(50) — Foreign key → Place.place_id — NOT NULL

LostItem

  • lost_item_id — VARCHAR(50) — Primary key — NOT NULL
  • lost_item_name — VARCHAR(255) — NOT NULL
  • lost_item_detail — TEXT
  • lost_item_lost_date — DATETIME
  • lost_item_image — VARCHAR(500)
  • lost_item_state — ENUM('LOST', 'FOUND', 'RESOLVED') — NOT NULL
  • lost_item_enter_date — DATETIME — NOT NULL
  • place_id — VARCHAR(50) — Foreign key → Place.place_id — NOT NULL
  • minor_category_id — VARCHAR(50) — Foreign key → MinorCategory.minor_category_id — NOT NULL
  • user_email — VARCHAR(255) — Foreign key → NormalUser.user_email — NOT NULL

MajorCategory

  • major_category_id — VARCHAR(50) — Primary key — NOT NULL
  • major_category_name — VARCHAR(100) — NOT NULL

MediumCategory

  • medium_category_id — VARCHAR(50) — Primary key — NOT NULL
  • medium_category_name — VARCHAR(100) — NOT NULL
  • major_category_id — VARCHAR(50) — Foreign key → MajorCategory.major_category_id — NOT NULL

MinorCategory

  • minor_category_id — VARCHAR(50) — Primary key — NOT NULL
  • minor_category_name — VARCHAR(100) — NOT NULL
  • medium_category_id — VARCHAR(50) — Foreign key → MediumCategory.medium_category_id — NOT NULL

NormalUser

  • user_email — VARCHAR(255) — Primary key — NOT NULL
  • first_name — VARCHAR(50) — NOT NULL
  • last_name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • date — DATETIME — NOT NULL
  • user_type — ENUM('STUDENT', 'TEACHER', 'NORMAL') — NOT NULL

Place

  • place_id — VARCHAR(50) — Primary key — NOT NULL
  • place_name — VARCHAR(100) — NOT NULL
  • place_coordinate — VARCHAR(100)

Student

  • user_email — VARCHAR(255) — Foreign key → NormalUser.user_email — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • std_num — VARCHAR(50) — NOT NULL
  • account_state — VARCHAR(20)
  • class_id — VARCHAR(50) — Foreign key → Class.class_id — NOT NULL

Teacher

  • user_email — VARCHAR(255) — Foreign key → NormalUser.user_email — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • class_id — VARCHAR(50) — Foreign key → Class.class_id — NOT NULL

User_Agreement

  • agreement_id — VARCHAR(50) — Foreign key → Agreement.agreement_id — NOT NULL
  • user_email — VARCHAR(255) — Foreign key → NormalUser.user_email — NOT NULL
  • check — CHAR(1) — NOT NULL
  • date — DATETIME — NOT NULL