Re:vive
Tables (9)
Board (게시판)
- b_id (번호) — LONG — Primary key — NOT NULL
- b_title (제목) — VARCHAR(255)
- b_content (내용) — VARCHAR(255)
- b_create_at (작성시간) — VARCHAR(255)
- b_update_at (수정시간) — VARCHAR(255)
- b_author (작성자) — VARCHAR(255)
- b_private (공개유무) — VARCHAR(255)
C_Reservation (상담예약정보)
- cr_id (번호) — LONG — Primary key — NOT NULL
- u_id (유저번호) — LONG
- c_id (상담사번호) — LONG
- u_name (유저이름) — VARCHAR(255)
- c_name (상담사이름) — VARCHAR(255)
- cr_date (상담날짜) — VARCHAR(255)
- cr_start (상담시작시간) — VARCHAR(255)
- cr_end (상담완료시간) — VARCHAR(255)
- cr_status (상담진행상태) — VARCHAR(255)
ChatLog (채팅내역)
- cl_id (번호) — LONG — Primary key — NOT NULL
- u_id (유저번호) — LONG
- c_id (상담사번호) — LONG
- cl_num (채팅방번호) — VARCHAR(255)
- cl_record (채팅내역) — VARCHAR(255)
ChattingRoom (채팅방)
- r_id (번호) — LONG — Primary key — NOT NULL
- u_id (유저번호) — LONG
- c_id (상담사번호) — LONG
Counselor (상담사정보)
- c_id (번호) — LONG — Primary key — NOT NULL
- c_name (이름) — VARCHAR(255)
- c_phone (전화번호) — VARCHAR(255)
- c_level (급수) — INT
- c_number (자격번호) — VARCHAR(255)
- c_location (활동지역) — VARCHAR(255)
Emotion (공감)
- e_id (번호) — LONG — Primary key — NOT NULL
- u_id (유저아이디) — LONG
- b_id (게시판아이디) — LONG
- e_check (체크유무) — BOOLEAN
Poem (시정보)
- p_id (번호) — LONG — Primary key — NOT NULL
- p_title (제목) — VARCHAR(255)
- p_content (내용) — VARCHAR(255)
- p_poet (시인) — VARCHAR(255)
User (유저DB)
- u_id (유저번호) — LONG — Primary key — NOT NULL
- u_email (이메일(ID)) — VARCHAR(255)
- u_name (유저이름) — VARCHAR(255)
- u_password (비밀번호) — VARCHAR(255)
- u_create_at (가입일) — VARCHAR(255)
- u_role (권한) — VARCHAR(255)
- u_adress (주소) — VARCHAR(255)
- u_delete_at (탈퇴일) — VARCHAR(255)
User_payment (결제내역)
- pay_id (결제번호) — LONG — Primary key — NOT NULL
- pay_emial (결제자이메일) — VARCHAR(255)
- pay_price (결제가격) — INT
- pay_date (결제날짜) — VARCHAR(255)