신한 해커톤
테이블 (26)
BankAccount
- accountID — INT
- userID — INT
- accountNumber — VARCHAR(255) — NOT NULL
- bankName — VARCHAR(255) — NOT NULL
- accountType — ENUM('checking', 'savings') — NOT NULL
- balance — DECIMAL(15, 2) — NOT NULL
- accountStatus — ENUM('active', 'inactive') — NOT NULL
Booth
- boothID — INT
- boothName — VARCHAR(255) — NOT NULL
- festivalID — INT
- ownerID — INT
- locationCode — VARCHAR(255) — NOT NULL
- category — VARCHAR(255) — NOT NULL
- menuList — TEXT
- priceList — TEXT
BoothWaitingStatus
- boothID — INT
- waitCount — INT — NOT NULL
- estWaitTime — INT — NOT NULL
- lastUpdateAt — DATETIME — NOT NULL
Chat
- chatID — INT
- groupID — INT
- userID — INT
- message — TEXT
- timestamp — DATETIME — NOT NULL
ChatNotification
- userID — INT
- chatID — INT
- notificationEnabled — BOOLEAN — NOT NULL
Event
- eventID — INT
- groupID — INT
- eventName — VARCHAR(255) — NOT NULL
- eventDate — DATETIME — NOT NULL
- location — VARCHAR(255)
- description — TEXT
EventAttendance
- attendanceID — INT
- eventID — INT
- userID — INT
- status — ENUM('confirmed', 'pending', 'cancelled') — NOT NULL
Festival
- festivalID — INT
- festivalName — VARCHAR(255) — NOT NULL
- startDate — DATETIME — NOT NULL
- endDate — DATETIME — NOT NULL
- description — TEXT
FilePermission
- fileID — INT
- userID — INT
- permission — ENUM('read', 'write', 'delete') — NOT NULL
FileUpload
- fileID — INT
- groupID — INT
- fileName — VARCHAR(255) — NOT NULL
- fileSize — INT — NOT NULL
- uploadDate — DATETIME — NOT NULL
- uploadedBy — INT
GroupEdit
- editID — INT
- groupID — INT
- editorID — INT
- editDate — DATETIME — NOT NULL
- editDetails — TEXT
GroupInfo
- groupID — INT
- groupName — VARCHAR(255) — NOT NULL
- category — VARCHAR(255) — NOT NULL
- creatorID — INT
- memberCount — INT — NOT NULL
- description — TEXT
- createdAt — DATETIME — NOT NULL
GroupMember
- memberID — INT
- groupID — INT
- userID — INT
- role — ENUM('admin', 'member') — NOT NULL
- joinDate — DATETIME — NOT NULL
Menu
- menuID — INT
- boothID — INT
- menuName — VARCHAR(255) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- category — VARCHAR(255)
- description — TEXT
NotificationSetting
- notificationType — ENUM('info', 'warning', 'error') — 기본 키 — NOT NULL
- userID — INT
- allowed — BOOLEAN — NOT NULL
OrderTable
- orderID — INT
- userID — INT
- boothID — INT
- menuID — INT
- qty — INT — NOT NULL
- orderTotal — DECIMAL(15, 2) — NOT NULL
- orderStatus — ENUM('placed', 'paid', 'cooking', 'ready', 'completed') — NOT NULL
Payment
- paymentID — INT
- orderID — INT
- paymentAmount — DECIMAL(15, 2) — NOT NULL
- paymentMethod — ENUM('SHINHAN_PAY', 'KAKAO_PAY', 'TOSS_PAY', 'NAVER_PAY') — NOT NULL
Poll
- pollID — INT
- groupID — INT
- title — VARCHAR(255) — NOT NULL
- endDate — DATETIME — NOT NULL
- status — ENUM('active', 'completed') — NOT NULL
PollOption
- optionID — INT
- pollID — INT
- optionText — VARCHAR(255) — NOT NULL
- votes — INT — NOT NULL
PollVote
- voteID — INT
- pollID — INT
- userID — INT
- optionID — INT
- voteTime — DATETIME — NOT NULL
PushNotification
- notificationID — INT
- userID — INT
- message — TEXT — NOT NULL
- notificationType — ENUM('info', 'warning', 'error') — NOT NULL
- timestamp — DATETIME — NOT NULL
Registration
- userID — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- status — ENUM('active', 'inactive') — NOT NULL
Savings
- savingsID — INT
- userID — INT
- savingsType — ENUM('savings', 'time_deposit') — NOT NULL
- interestRate — DECIMAL(5, 2) — NOT NULL
- depositAmount — DECIMAL(15, 2) — NOT NULL
- maturityDate — DATE
- balance — DECIMAL(15, 2) — NOT NULL
- status — ENUM('active', 'closed') — NOT NULL
Transaction
- transactionID — INT
- accountID — INT
- transactionType — ENUM('deposit', 'withdrawal', 'transfer') — NOT NULL
- amount — DECIMAL(15, 2) — NOT NULL
- transactionDate — DATETIME — NOT NULL
- transactionDetails — TEXT
User
- userID — INT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- department — VARCHAR(255)
- studentID — VARCHAR(255)
- profileImage — BLOB
- bio — TEXT
- userType — ENUM('student', 'admin') — NOT NULL
Waiting
- ticketNo — INT
- userID — INT
- boothID — INT
- waitCount — INT — NOT NULL
- estWaitTime — INT — NOT NULL
- joinTime — DATETIME — NOT NULL