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