ㄹ
Tables (18)
branch
- branch_id — bigint — Primary key — NOT NULL
- branch_latitude — double — NOT NULL
- branch_longitude — double — NOT NULL
- branch_address — varchar(255) — NOT NULL
- branch_name — varchar(255) — NOT NULL
- branch_phone_number — varchar(255)
- road_from_station — varchar(255)
branch_image
- image_id — bigint — Foreign key → image.image_id — NOT NULL
- branch_id — bigint — Foreign key → branch.branch_id
comment
- id — bigint — Primary key — NOT NULL — 댓글 ID
- content — varchar(255) — NOT NULL — 댓글 내용
- created_date — datetime
- last_modified_date — datetime — 수정 일시
- member_id — bigint — Foreign key → member.member_id — 회원 ID
- post_id — bigint — Foreign key → post.id — 게시글 ID
company
- company_id — bigint — Primary key — NOT NULL
- company_head_count — int
- contract_end_date — date — NOT NULL
- contract_start_date — date — NOT NULL
- business_type — varchar(255) — NOT NULL
- company_email_domain — varchar(255) — NOT NULL
- company_name — varchar(255) — NOT NULL
- contract_manager_contact — varchar(255) — NOT NULL
- contract_manager_name — varchar(255) — NOT NULL
- representative_contact — varchar(255) — NOT NULL
- representative_name — varchar(255) — NOT NULL
image
- image_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- dtype — varchar(31) — NOT NULL
- image_url — varchar(255) — NOT NULL
member
- member_id — bigint — Primary key — NOT NULL
- member_delete_check — bit(1) — NOT NULL
- member_sms_agree — bit(1) — NOT NULL
- company_id — bigint — Foreign key → company.company_id
- created_date — datetime
- image_id — bigint — Foreign key → member_image.image_id
- last_modified_date — datetime
- member_email — varchar(255) — NOT NULL
- member_name — varchar(255) — NOT NULL
- member_nickname — varchar(255) — NOT NULL
- member_phone — varchar(255) — NOT NULL
- member_pw — varchar(255) — NOT NULL
- member_job — enum('OWNER','OFFICE','FINANCE','HRD','PROMOTION','ITDEV','ITPLAN','SALE','DESIGN','SERVICE','CONTENTS','RND','PROFESSIONAL','MD','INSURANCE','ETC')
- member_role — enum('ROLE_USER','ROLE_ADMIN')
member_image
- image_id — bigint — Foreign key → image.image_id — NOT NULL
member_reservation
- member_reservation_id — bigint — Primary key — NOT NULL
- member_reservation_status — enum('WAITING','ACCEPTED','REJECTED','CANCELED')
- member_reservation_type — enum('REPRESENTATIVE','PARTICIPANT')
- member_id — bigint — Foreign key → member.member_id
- reservation_id — bigint — Foreign key → reservation.reservation_id
notification
- id — bigint — Primary key — NOT NULL — 알림 ID
- image — varchar(255)
- title — varchar(50) — NOT NULL — 알림 제목
- content — varchar(255) — NOT NULL — 알림 내용
- target_id — bigint — NOT NULL — 알림 대상 ID
- type — varchar(50) — NOT NULL — 알림 타입
- created_date — datetime — 생성 일시
- last_modified_date — datetime — 수정 일시
- member_id — bigint — Foreign key → member.member_id — NOT NULL — 회원 ID
post
- id — bigint — Primary key — NOT NULL — 게시글 ID
- category — enum('JOB', 'OWNER', 'OFFICE', 'FINANCE', 'HRD', 'PROMOTION', 'ITDEV', 'ITPLAN', 'SALE', 'DESIGN', 'SERVICE', 'CONTENTS', 'RND', 'PROFESSIONAL', 'MD', 'INSURANCE', 'ETC', 'INTEREST', 'FREE_BOARD', 'COMPANY_LIFE', 'INVESTMENT_FINANCE', 'STUDY_PROMOTION', 'EXERCISE', 'FOOD', 'CULTURAL_LIFE', 'FAMILY_PET')
- tag — enum('FREE', 'INTERVIEW', 'CAREER', 'INSIGHT', 'QUESTION', 'CHAT', 'INFO', 'BRAG')
- title — varchar(255) — NOT NULL — 게시글 제목
- content — varchar(255) — NOT NULL — 게시글 내용
- view_count — int — NOT NULL — 조회수
- like_count — int — NOT NULL — 좋아요 수
- comment_count — int — NOT NULL — 댓글 수
- created_date — datetime — 생성 일시
- last_modified_date — datetime — 수정 일시
- member_id — bigint — Foreign key → member.member_id — 회원 ID
post_image
- image_id — bigint — Foreign key → image.image_id — NOT NULL
- post_id — bigint — Foreign key → post.id
post_like
- post_id — bigint — Primary key — NOT NULL — 게시글 아이디
- member_email — varchar(255) — Primary key — NOT NULL — 회원 이메일
private_post
- private_post_id — bigint — Primary key — NOT NULL
- private_post_title — varchar(50) — NOT NULL
- private_post_content — varchar(500) — NOT NULL
- created_date — datetime
- last_modified_date — datetime
- member_id — bigint — Foreign key → member.member_id
- branch_id — bigint — Foreign key → branch.branch_id
- private_post_answer_id — bigint — Foreign key → private_post_answer.private_post_answer_id
private_post_answer
- private_post_answer_id — bigint — Primary key — NOT NULL
- private_post_answer_content — varchar(500) — NOT NULL
- created_date — datetime
- last_modified_date — datetime
reservation
- reservation_id — bigint — Primary key — NOT NULL
- created_date — datetime
- last_modified_date — datetime
- reservation_end_date_time — datetime
- reservation_start_date_time — datetime
- space_id — bigint — Foreign key → space.space_id
- reservation_name — varchar(255) — NOT NULL
space
- space_id — bigint — Primary key — NOT NULL
- can_video_conference — bit(1)
- is_private — bit(1)
- meeting_room_capacity — int
- projector_exists — bit(1)
- space_floor — int — NOT NULL
- branch_id — bigint — Foreign key → branch.branch_id
- dtype — varchar(31) — NOT NULL
- space_name — varchar(255) — NOT NULL
- meeting_room_type — enum('MINI','STANDARD','MEDIUM','STATE')
- focus_desk_number — int
- can_reserve — bit(1)
space_image
- image_id — bigint — Foreign key → image.image_id — NOT NULL
- space_id — bigint — Foreign key → space.space_id
station_names
- branch_id — bigint — Foreign key → branch.branch_id — NOT NULL
- station_to_branch — varchar(255)