test01
테이블 (17)
Chat
- ID — BIGINT — 기본 키 — NOT NULL
- studyroom_ID — BIGINT — NOT NULL
- participant_ID — BIGINT — NOT NULL
- message — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
DailyStudyRecord
- ID — BIGINT — 기본 키 — NOT NULL
- user_ID — BIGINT — NOT NULL
- record_date — DATE — NOT NULL
- daily_study_time — INT — NOT NULL
- daily_away_time — INT — NOT NULL
LoginHistory
- ID — BIGINT — 기본 키 — NOT NULL
- user_ID — BIGINT — NOT NULL
- login_Date — DATETIME — NOT NULL
- login_Time — DATETIME — NOT NULL
Report
- ID — BIGINT — 기본 키 — NOT NULL
- reporter_ID — BIGINT — NOT NULL
- to_user_ID — BIGINT — NOT NULL
- studyroom_ID — BIGINT — NOT NULL
- chat_ID — BIGINT
- reason — ENUM — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
Restriction
- ID — BIGINT — 기본 키 — NOT NULL
- reported_ID — BIGINT — NOT NULL
- studyroom_ID — BIGINT — NOT NULL
- type — ENUM — NOT NULL — 'general', 'strong'
- source — ENUM — NOT NULL — 'AUTO', 'ADMIN'
- reason — TEXT — NOT NULL
- started_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- update_at — DATETIME
RoomHistory
- ID — BIGINT — 기본 키 — NOT NULL
- studyroom_ID — BIGINT — NOT NULL
- user_ID — BIGINT — NOT NULL
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME — NOT NULL — 주문 = PENDING 송금 = PAID 취소 = CANCEL
StudyRoom
- ID — BIGINT — 기본 키 — NOT NULL
- participants_number — INT — NOT NULL
- status — ENUM — NOT NULL — 'OPEN', 'FULL
- CLOSE, — `capacity` — NOT NULL — 대기 = waiting 이체 완료 = confirmed 실패 = failed
StudyRoomParticipant
- ID — BIGINT — 기본 키 — NOT NULL
- user_ID — BIGINT — NOT NULL
- studyroom_ID — BIGINT — NOT NULL
- join_time — DATETIME — NOT NULL
- leave_time — DATETIME — NOT NULL — 주문 = PENDING 송금 = PAID 취소 = CANCEL
- focus_status — ENUM — NOT NULL — 'FOCUS', 'AWAY
- REST, — `Field` — NOT NULL
StudyTimer
- ID — BIGINT — 기본 키 — NOT NULL
- participant_ID — BIGINT — NOT NULL
- target_time — INT — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME
- study_duration — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Title
- ID — BIGINT — 기본 키 — NOT NULL
- name — varchar(20) — NOT NULL
- description — varchar — NOT NULL — BETWEEN 1 AND 5
- title_code — ENUM — NOT NULL
- title_icon — varchar — NOT NULL
- condition_type — ENUM — NOT NULL — 'ATTENDANCE_DAYS', 'PRAISE_COUNT
- STUDY_TIME, — `condition_value` — NOT NULL
User
- user — ID` — 기본 키 — NOT NULL
- user_title_ID — BIGINT — NOT NULL
- email — varchar(100) — NOT NULL
- password — varchar(70)
- social_provider — ENUM — NOT NULL — 'GOOGLE', 'KAKAO
- LOCAL, — `nickname` — NOT NULL — 일반 신고 수
- user_status — ENUM — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
UserStudyStat
- ID — BIGINT — 기본 키 — NOT NULL
- user_ID — BIGINT — NOT NULL
- total_attendance_days — INT — NOT NULL
- continue_attendance_days — INT — NOT NULL
- last_attendance_date — DATE
- total_study_time — INT — NOT NULL
- total_away_time — INT — NOT NULL
- continue_focusdays_overhour — INT — NOT NULL
- title_count — INT — NOT NULL
UserTitle
- ID — BIGINT — 기본 키 — NOT NULL
- Title_ID — BIGINT — NOT NULL
- user_ID — BIGINT — NOT NULL
- acquired_at — DATETIME — NOT NULL
- isEquipped — boolean — NOT NULL
고객 (customers)
- 고객아이디 (cust_id) — number(5) — 기본 키 — NOT NULL
- 고객명 (cust_name) — varchar2(50)
- 배송지주소 (cust_address) — varchar2(250)
- 전화번호 (cust_telnum) — varchar2(20)
상품 (goods)
- 상품번호 (gid) — varchar2(4) — 기본 키 — NOT NULL
- 상품명 (goods_name) — varchar2(30)
- 가격 (goods_price) — number(6)
주문 (orders)
- 주문번호 (order_no) — char(13) — 기본 키 — NOT NULL
- 주문금액 (order_amt) — number(8)
- 고객아이디 (cust_id) — number(5) — 외래 키 → 고객.고객아이디 — NOT NULL
주문상품 (order_goods)
- 주문번호 (order_no) — char(13) — 외래 키 → 주문.주문번호 — NOT NULL
- 상품번호 (gid) — varchar2(4) — 외래 키 → 상품.상품번호 — NOT NULL
- 주문수량 (order_qty) — number(3)