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)